• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

External table is not in the expected format

V

Villalobos

Active Member
Hi,

I would like to ask your help regarding data transfer from closed workbook. After many attempts I feel that I am completly lost.

The attached Components.xls file generated by SAP and when I want to transfer the data I receive "External table is not in the expected format" error message.
By the way if I "Save As" the file in .xls format then the code is working fine. My target would be that to transfer the data without "Open" or "Save As" the source file.

Thank you in advance for your help!
 

Attachments

  • Components.xls
    25.2 KB · Views: 2
  • targetfile.xlsm
    25.2 KB · Views: 3
AFAIK - This most often occurs when accessing external data using Microsoft.Jet.OLEDB.4.0 and Extended Properties=Excel 8.0

Try using Provider=Microsoft.ACE.OLEDB.12.0 & Extended Properties=Excel 12.0
 
Your .xls exported file is not in proper BIFF8 format so it is not a true .xls. That is why opening and saving it fixes the issue.
 
You must log in or register to reply here.
Back
Top