Forum Discussion
Date format error
Hello,
I Have a set of 4 Excel files in folder I, Through the get data folder option i loaded them, now when I am trying to transform data for one of the columns from text to date format i am getting an error
"ole db or odbc error " data format error external table is not in the expected format
How can i solve this
3 Replies
Check that the excel files are of .xlsx and not .xls file types. If not, you need to resave them as Microsoft Excel Workbook.
Thanks for ur help , however the file are stored in Microsoft Excel Worksheet (.XLSX) format only. what else could be the reason .
BR
Hi anwarsa ,
This is the related document, you can view this content:
External table is not in the expected format. - Microsoft Fabric Community
DataFormat.Error: External table is not in expected format (microsoft.com)
OLE DB or ODBC Error: [DataFormat.Error] External ... - Microsoft Fabric Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
