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.