Ssis Excel External Table Is Not In The Expected Format

Getting "External table is not in the expected format." error while

Ssis Excel External Table Is Not In The Expected Format. Web i can open it in excel, without any error or warning from excel. In a ssis etl transformation i'm trying to load a certain.xls file.

Web when trying to select a table (tab) i get the following error message external table is not in the expected format.”. In a ssis etl transformation i'm trying to load a certain.xls file. I have several identical files with similar schemas, and all of them. Web external table is not in the expected format. If i open it in excel and. Web i can open it in excel, without any error or warning from excel. External table is not in the expected format. But when i try to open it in ssis or even in powerbi, i get the following message: This happens when the excel file is corrupted and cannot be opened by access database engine (ole db provider) even if you can open the file. Web since you state it works when saved as an.xls file i would guess you are using the wrong connection string/provider.

But when i try to open it in ssis or even in powerbi, i get the following message: Web i can open it in excel, without any error or warning from excel. I have several identical files with similar schemas, and all of them. Web external table is not in the expected format. Web when trying to select a table (tab) i get the following error message external table is not in the expected format.”. If i open it in excel and. But when i try to open it in ssis or even in powerbi, i get the following message: This happens when the excel file is corrupted and cannot be opened by access database engine (ole db provider) even if you can open the file. In a ssis etl transformation i'm trying to load a certain.xls file. Web since you state it works when saved as an.xls file i would guess you are using the wrong connection string/provider. External table is not in the expected format.