change 1-1-10$ to "1-1-10$"
see what happens.
-----Original Message-----
From: Brian Thornton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 2:18 AM
To: CF-Talk
Subject: Excel as a datasource.
I have...
<cfquery DATASOURCE="Excels" NAME="GetDesc">
SELECT *
FROM 1-1-01$
</cfquery>
This is a query for a excel sheet. I'm getting a error S1000 saying
"[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'.
It may not be a database that your application recognizes, or the file may
be corrupt."
Any ideas. FTP is happening completely and correctly. Anyone have any
experience making Excel 2000 Spread sheet web based...
Damn cheap customers.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
