Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel spreadsheet as a datasource for ColdFusion.
- Thread starter apirri
- Start date
There is an excel odbc driver that should allow you to connect to your excel spreadsheet. Everything I've read though tends to discourage doing this as it seems that people usually have trouble with it. The best approach is to convert your excel spreadsheet to Access and connect to it through the access odbc driver.
If you must connect directly to the spreadsheet though, I would try using the excel odbc driver first although there may be some alternatives such as using DDE through com.
GJ
If you must connect directly to the spreadsheet though, I would try using the excel odbc driver first although there may be some alternatives such as using DDE through com.
GJ
Yeah, check out to learn more about COM objects (cfobject) and Excel. Good luck.
<webguru>iqof188</webguru>
<webguru>iqof188</webguru>
Guest_imported
New member
- Jan 1, 1970
- 0
It is simple.
the query is something like
<CFQUERY NAME= "GetData" DATASOURCE= "data">
SELECT *
FROM `worksheetinexcel$`
</CFQUERY>
The FROM is the big difference to a call on an ACCESS DB.
the worksheetinexcel is a worksheet in your spreadsheet.
then you treat the rest of the code the same.
the query is something like
<CFQUERY NAME= "GetData" DATASOURCE= "data">
SELECT *
FROM `worksheetinexcel$`
</CFQUERY>
The FROM is the big difference to a call on an ACCESS DB.
the worksheetinexcel is a worksheet in your spreadsheet.
then you treat the rest of the code the same.
- Status