May 16, 2011 at 7:31 am
Hi There,
I am new to sql. I am using SQL server 2000. Here i wanna to import excel data to my data base. The table name should be same as my excel sheet name. I need to automate it.
The code i have used for this is given below:
SELECT * into #Vimal
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\Vimalkumar\Test.xls',
'SELECT * FROM [Test$]')
But when i use to execute the code, i am getting the error mentioned below
"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.]."
Could any body help me to come out of this?
Regards,
Vimal Srivastava
May 16, 2011 at 9:14 am
Is this a one time thing or a regular occurrence? If it's regular, have you looked at DTS? You can use the Import wizard from EM to create a package that will do this.
Are you sure the SQL Server database engine service account has rights to read the file? This has nothing to do with your rights or your workstation. The path and security must be from the server instance.
Editor: moved to SQL 2000
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply