[thelist] ColdFusion : query a XLS

s t e f || n o t a - b e n e . o r g stef at nota-bene.org
Thu Oct 26 05:17:14 CDT 2000

[sender: s t e f || n o t a - b e n e . o r g || date: 11:39 26/10/2000 +0200]
>Hello all,
>how the hell do you query an Excel Database in coldfusion???
>I declared the right DSN, I have a table called liste, and when I perform 
>a simple "select * from liste" the server replies:
>"ODBC Error Code = S0002 (Base table not found)".

It's OK, after fumbling with MSDN for more than an hour I found that the 
spreadsheet must be addressed like so : name + "$"
So my query is now "select * from liste$"

Amazing, isn't it?

s t e f

More information about the thelist mailing list