This content has been marked as final. Show 7 replies
I start working at new computer and have an issue with OBDC connection.
When I load files I get following issue "External table is not in the expected format".
Usually I use following code to make connection:
For Each vFile in FileList('$(vPath)\*xlsx')
ODBC CONNECT32 TO [Excel Files;DBQ=$(vFile)];
// Read list of sheets
Also I installed ODBC driver from microsoft site, but problem still exist.
How can I solve this problem