QlikView: MS Access ODBC Load Error

[#1]

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# )

[Peter_Cammaert]

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.

[pradosh_thakur]

Hi

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

so try this.

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 StartDate >#8/31/2017#

AND StartDate <#10/4/2017# )

regards

Pradosh