Error while importing data from Excel to SQL server 2000 table

Question

Hi,

I am getting error when i am importing data from excel to SQL server table. Error is:

Error Source: Microsoft JET Database Engine. Description : External table is not in the expected format. (Microsoft JET Database Engine)

When i copy the data of excel file which is coming from Oracle database to a new excel file then it is working fine. But with same excel file giving error. I have checked the format of each column of the excel getting from Oracle.

Answer 1

0

You have extra rows in the excel file. Run this with OPENROWSET():

SELECT *             
FROM            
OPENROWSET('Microsoft.Jet.OLEDB.4.0',            
'Excel 8.0;Database=<location of file and name>.xls',            
'SELECT * FROM [<worksheet>$]')

and you should see the extra rubbish in the workbook.

answered Nov 10 '09 at 07:17 AM

RickD
1.6k ● 1 ● 1 ● 4

(comments are locked)

Answer 2

0

There is a possibility of corrupting excel data. You would finish the exporting with how to repair excel files after recovery

Application http://www.repairexcel.recoverytoolbox.com will help to recover the integrity of data and export it to sql table

answered Apr 09 at 06:24 PM

stevenorris
0

(comments are locked)

Answer 3

0

Workaround assuming you are using DTS: Save the excel file as a CSV or other delimited text file and import with that instead. This can be done quite easily in Excel.

answered May 26 '11 at 08:23 AM

megamanblue
310 ● 6 ● 6 ● 8

(comments are locked)

Error while importing data from Excel to SQL server 2000 table

Follow this question

Related Questions