[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