Skip to main content
Inspiring
May 19, 2010
Question

Problem with datasource CF8/Access/Excel

  • May 19, 2010
  • 1 reply
  • 764 views

I have a setup that I have been using for a long time where I read Excel databases without having to specify a datasource for each one. I created an Access datasource, let's say "accessdatasource', and then CF7 running on IIS6 I run the SQL query below to read the top record in an Excel spreadsheet, where #data_filename# is the name of the Excel XLS file. Allowing me to read as many as I like in a LOOP

<cfquery name="gettop" DATASOURCE="accessdatasource" >
SELECT TOP 1 camp
FROM [Sheet1$]
IN '#report_location#\#data_filename#' 'EXCEL 5.0;'
</cfquery>

I want to use this on another site, but the other site is on a CF8 server, running IIS7 (shared server on Godaddy), on their IIS7 they do not have the option to set up an Access dbase, only SQL, so I am unable to set up the 'dummy' datasource that I can utilize this way.

Does anybody know of a simple work around for this as I must loop over many XLS files.

I previously used a dynamic datasource approach but had problems with it locking and being unable to delete/drop ready for the next one

Thanks

Mark

This topic has been closed for replies.

1 reply

Inspiring
May 20, 2010

You might try using Ben Nadel's POI utility.

http://www.bennadel.com/projects/poi-utility.htm