3 Replies Latest reply: Apr 15, 2016 12:26 AM by Brian Joseph RSS

    Qlik Sense: MS Access ODBC Load Error

    George Barrett

      Hello Community,

       

      I am having an issue loading data into Qlik Sense from a MS Access table via ODBC connection. I am able to see the fields and data in the data preview of the connection, but when the script is generate and loaded, a SQL error appears. The following is my script that is generated without modification and the error message that comes with it. One thing I noticed that was off was the script did not generate  closing quotes or comma after the Credit Union field in the SQL Select statement. When I add that, the error still appears. The version of Qlik Sense is Qlik Sense 2.2.3 + Build: 3.7.release/ms15. Any help would be appreciated.

       

      LIB CONNECT TO 'AccessDB_SIT (pscu_gbarrett)';

       

       

      REM LOAD "Help Desk Agent",

          "Date   (mm/dd/yyyy)",

          "Time                (12 or 24 hour clock)",

          "Employee ID",

          "Agent Name",

          Location,

          "Call Type",

          "Credit Union                                                    ",

          Category,

          Reason,

          "Info in KB?",

          Notes;

      SQL SELECT "Help Desk Agent",

          "Date   (mm/dd/yyyy)",

          "Time                (12 or 24 hour clock)",

          "Employee ID",

          "Agent Name",

          Location,

          "Call Type",

          "Credit Union                                                    ",

          Category,

          Reason,

          "Info in KB?",

          Notes

      FROM "C:\QlikData\Call Center\Help Desk Tracker.accdb".Tracker;

       

      The following error occurred:

      SQL##f - SqlState: 07001, ErrorCode: 4294964286, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.