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.
You have extra rows in the excel file. Run this with OPENROWSET():
and you should see the extra rubbish in the workbook.
answered Nov 10 '09 at 07:17 AM
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