Qlik Sense: MS Access ODBC Load Error

gbarrett — Thu, 31 Mar 2016 15:47:00 GMT

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.

Re: Qlik Sense: MS Access ODBC Load Error

awhitfield — Thu, 31 Mar 2016 15:55:31 GMT

Hi George,

check out the following thread:

https://qlikcommunity.qliktech.com/thread/150355

Andy

Re: Qlik Sense: MS Access ODBC Load Error

gbarrett — Thu, 31 Mar 2016 16:15:44 GMT

I figured out what was wrong but I don't know why it is wrong. The question mark in the "Info in KB?" field was causing the issue. Once the question mark was removed from the field name in the Access table, the script worked. Can anyone elaborate on why that happened and if other special characters can do this as well? Thank you.

Re: Qlik Sense: MS Access ODBC Load Error

Anonymous — Fri, 15 Apr 2016 04:26:58 GMT

It's probably because it is an Access wildcard like '*'

topic Re: Qlik Sense: MS Access ODBC Load Error in Connectivity & Data Prep

Qlik Sense: MS Access ODBC Load Error

Re: Qlik Sense: MS Access ODBC Load Error

Re: Qlik Sense: MS Access ODBC Load Error

Re: Qlik Sense: MS Access ODBC Load Error