Hi!I'm trying to import data from an excel file into a sql table.I'm using MS SQL.For import,I use openrowset.The SQL command looks like this(in my asp page):SQLstr = "SELECT * INTO dbo.shopping_TSR FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database="+Server.MapPath("\\fileuploader\\upload\\tmb2.xls")+"', 'SELECT * FROM [Sheet1$]')" I'm getting the following 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.]What could be the cause of this error?The .xls file and the sql table are on differen t servers.Can anyone help?Thanks in advance.
import data from excel to sql
Posted - 2007-08-16 : 02:12:36
