Check this out,
http://www.cfcomet.com/Excel/index.cfm?ArticleID=0239B2E5-5FED-11D3-B3E9004033E03EF9
A query may be like:
<CFQUERY DATASOURCE="excel" NAME="getDataSheet">
SELECT *
FROM "Sheet1$"
-- or the ACTUAL sheet name
</CFQUERY>
HIH
Don Li
a Must-have for MS SQL Server database
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=14&threadid=751833
>I am trying to set up a DSN in CF5 running on a Windows 2003 server to
>either an excel spreadsheet, or csv file and have had no luck.
>If you have had a similar experience of frustration and might know of
>something I could be doing wrong, please let me know.
>
>Thank you,
>Drew Harris
>CEO: Quantum Delta
>me: http://QuantumDelta.com/files/DrewHarris.vcf
>my company: http://QuantumDelta.com
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
