topic Re: QlikView: MS Access ODBC Load Error in QlikView

QlikView: MS Access ODBC Load Error

Wed, 04 Oct 2017 15:10:53 GMT

Hi guys,

I am trying to connect to a MS Access Database to Qlikview & facing following error. Can anyone of you please help.

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

Concatenate

SQL SELECT "Business Unit" as Business_Unit,

CES as Customer_Effort_Score_Flag,

Promoters as Promoter_Flag,

"Site_Referrer",

StartDate as Start_Date,

"Survey_Name",

TCR as Completion_Response_Flag,

"TCR Count" as Total_Completion_Response_Flag,

Template as Template_Name

FROM "Qualtrics Survey Data.accdb".PushSurveyData

WHERE (Survey_Name = "PushSurvey- PPS Portal"

AND Start_Date >#8/31/2017#

AND Start_Date <#10/4/2017# )

Re: QlikView: MS Access ODBC Load Error

Peter_Cammaert — Mon, 09 Oct 2017 08:18:34 GMT

Maybe you should remove the underscores from your Start_Date field in the WHERE clause (twice). That field name isn't in use yet. It's called StartDate.

Re: QlikView: MS Access ODBC Load Error

pradosh_thakur — Mon, 09 Oct 2017 08:51:34 GMT

Where clause is getting applied on your Data base table so the field name there is StartDate and not Start_Date

so try this.