Date format error

[anwarsa]

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

[Anonymous]

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.

[ahmedoye]

Check that the excel files are of .xlsx and not .xls file types. If not, you need to resave them as Microsoft Excel Workbook.

[anwarsa]

Thanks for ur help , however the file are stored in Microsoft Excel Worksheet (.XLSX) format only. what else could be the reason .

BR