5 Replies Latest reply: Dec 11, 2015 2:02 AM by kok leong ong RSS

    connected to access mdb but not able to see tables

    kok leong ong

      Hi there,


      I able to connect the Ms Access mdb file , but after reload the script there is no tables for me to add.





      SET ThousandSep=',';

      SET DecimalSep='.';

      SET MoneyThousandSep=',';

      SET MoneyDecimalSep='.';

      SET MoneyFormat='£#,##0.00;-£#,##0.00';

      SET TimeFormat='hh:mm:ss';

      SET DateFormat='DD/MM/YYYY';

      SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

      SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

      SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

      ODBC CONNECT32 TO [MS Access Database;DBQ=Z:\RF TPUT\RF Tput.mdb];