Odd SQL Problem

I don't know if it's because its 11PM or what but I got a get of SQL working on MSQL client but wont work via cfquery significant amount of googleing was a nogo... Any ideas? select * into NewTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',     'Excel 8.0;Database=C:\Brian.xls;HDR=YES',     'SELECT * FROM [Sheet1$]') SQL MS comes back with "1500 record(s) added but cfcomes back with "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" turns out this is a generic message and could very to permissions to single quotes.... Any ideas or does anyone have cfquery example to the insert into?

----- Excess quoted text cut - see Original Post for more ----- I suspect that OPENROWSET isn't going to work with CF through JDBC. I'm not sure why - perhaps it expects the connection string to work from the machine running CF. You could try writing it as a stored procedure, then calling the sproc from CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or ons

Got it.. Thanks Dave. ----- Excess quoted text cut - see Original Post for more -----