Hi Zihang,

I used the "Microsoft Excel 2007/2010."

Also, the first column of my Excel is a concatenate formula of my next two columns.

Regards

Hi Rafael,
It's not recommended to use merged cells in columns, so would be better to remove them. 
Driver "Microsoft Excel 2007/2010" should be OK. 
The error shows that the Excel file has some "unexpected format", but we are not clear about what it is. Could you please upload the Excel file, if it does not contain any private or sensitive data? 
You can also try this to see if it helps solve the issue: 

• Repair a corrupted workbook - Microsoft Support
  • After repair, try use workflow to query on it again. 

Hi Zhihang,

What format of Excel column value is needed for the workflow to run smoothly?

This is the sample value of the Excel file. I can't upload the Excel file.

"Column 1: P409748-63.6600-5-C500001-ME-00008-0 - 245kV Porcelain Air Bushing_712-16462-003

Column 2: 245kV Porcelain Air Bushing_712-16462-003

Column 3: P409748-63.6600-5-C500001-ME-00008

Column 4: 0

Column 5: 1"

Regards

Hi Rafael, 

I tried on WF11 with the provided data on WF11, but failed to reproduce the issue. 

Please file a support ticket for further investigate. 

Regards

Hi Zihang,

Sorry for the late reply.

Thank you; I will open a case.

Regards

This is a known issue for newer Excel files when attempting to open them using older ODBC drivers. Please install Microsoft Access Database Engine 2016 and create an ODBC data source in Windows using the ACE ODBC driver for Excel instead of the old Jet driver.

Hi Miruna,

Sorry for late response.

I need to uninstall the previous version of the ODBC that I was installed?

Regards 

You do not.

Another thing to keep in mind is that Excel only allows one connection at any time. Your spreadsheet cannot be open in Excel while Workflow is trying to access it.

Hi Miruna,

Already updated the ODBC.

I try if the error is resolved.

Regards