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

    ODBC connection issue

    Виталий Чуприна

      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

        Temp_Tables:

        sqltables;

       

      Also I installed ODBC driver from microsoft site, but problem still exist.

       

       

      How can I solve this problem