7 Replies Latest reply: Mar 2, 2016 7:06 AM by Colin Albert RSS

    ODBC connection issue

    Vitalii Chupryna

      Hi Guys,



      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