OldWilly
Programmer
- Mar 1, 2002
- 66
I am trying to read an Excel file called "email.xls".
I set up my CF Admin ODBC connection using Microsoft Excel Driver (*.xls). DSN = "xls". I put in Workbook/Directory ...
c:\Inetpub\ (the directory where the email.xls file exists) .. and it verfies ok.
Then in my CF code:
<cfquery datasource="xls" name="email">
SELECT * FROM email
</cfquery>
This code fails. Can anyone tell me what I am doing wrong?
I notice that CF Admin offers Excel version 97-2000 and lower. The Excel on my PC is 8.0 (I don't know if it makes a difference).
I set up my CF Admin ODBC connection using Microsoft Excel Driver (*.xls). DSN = "xls". I put in Workbook/Directory ...
c:\Inetpub\ (the directory where the email.xls file exists) .. and it verfies ok.
Then in my CF code:
<cfquery datasource="xls" name="email">
SELECT * FROM email
</cfquery>
This code fails. Can anyone tell me what I am doing wrong?
I notice that CF Admin offers Excel version 97-2000 and lower. The Excel on my PC is 8.0 (I don't know if it makes a difference).