Hi,
I am trying to import data from an Excel file to SQL Server.
The Excel file which I am using is an system-generated Excel file.
When we are trying to open this Excel file, an alert with appears something like
"The file you are ttrying to open, 'filename.xls', is in a different format than specified by the file extension. Verift that the file is not corrupted and is from a trusted source before opening the file. Do ypu want to open the file now?"
And when I am trying to import, I am getting the following error.
"External table is not in the expected format."
Is there any way to solve this issue?