Import excel data in database

• vimaltech04

  SSC Rookie

  Points: 28

  More actions

  May 17, 2011 at 2:04 am

  #236327

  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

• Sean Lange

  SSC Guru

  Points: 286609

  More actions

  May 17, 2011 at 8:20 am

  #1325835

  Please don't continue posting the same question again. Instead you should reply to Steve in your original thread here.

  Do not reply to this thread. Please respond to the original one.

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/