Link to home
Create AccountLog in
Avatar of HyperBPP
HyperBPP

asked on

Using T-SQL openrowset with Excel 2007

I'm using openrowset with MS SQL Server 2005 to update data in and excel spreadsheet (.xls).  However, I'm unable to do this to an excel 2007 spreadsheet (.xlsx).  Is this supported?  Do I need to adjust something in the OPENROWSET function params?  Like change Excel=8.0 to something?

UPDATE...
...OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Documents and Settings\ttalbott\Desktop\NT CBA\2009IIllustrative .xlsx;',
'SELECT Bin, .....
ASKER CERTIFIED SOLUTION
Avatar of Daniel Wilson
Daniel Wilson
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of HyperBPP
HyperBPP

ASKER

'bout time, I know, I know.