Import CSV into Sql Server with OPENROWSET
Posted on 2010-08-16
I'm trying to import a simple .csv into Sql Server 8 with OPENROWSET:
Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\IMPORTFILES\test.csv', 'SELECT * FROM [Sheet1$]')
I get the following error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].
I have verified the .csv file is valid and can be opened in Excel. I've done this is the past without errors, can't see what's wrong this time.