looks like i'm a little late on this one, but thought it might be handy for you or others anyway... Using Excel Spreadsheets as Web Data Sources http://evolt.org/index.cfm?menu=8&cid=591 it's an ASP solution, but prepping the file is still the same... as is the driver... > From: "s t e f || n o t a - b e n e . o r g" <stef at nota-bene.org> > > > >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$"