Bulk insert

[b00gieman]

Hi!
I want to import data from an excel file into a ms sql table.I tried to use openrowset for this,but i ended up recieving this error:

[Microsoft][ODBC SQL Server Driver][SQL Server]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.]

Could I use bulk insert for this,instead of openrowset?

 

[nomadicalloy]

what version of sql you are using (2000 or 2005)? please look at following link

http://msdn2.microsoft.com/en-us/library/ms188365.aspx

thanks


This is Signature

http://www.xpherion.com/

 

[b00gieman]

I'm using SQL server 2000