Script Error while connecting data from MS Access to Qlikview

[#1]

Hi,

I am facing script error while trying to connect a data table from MS Access to Qlikview. Here is the error message,

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

Concatenate

SQL SELECT "Browser Meta Info-Browser" as Browser_Meta_Info_Browser,

    "Browser Meta Info-Version" as Browser_Meta_Info_Version ,

    "Business Unit" as Business_Unit,

    CES as Customer_Effort_Score_Flag,

    "CES Count" as Total_Customer_Effort_Score_Flag,

    "Count" as Satisfied_Response_Flag,

    CountryCode as Country_Code,

    Csat as Completely_Satisfied_Flag,

    Detractors as Detractor_Flag,

    DocumentID as Document_Id,

    Dsat as Dissatisfied_Flag,

    GeoLocation as Geo_Location,

    "Is your product under warranty?" as Warranty_Type,

    LanguageCode as Language_Code,

    "NPS Count" as Recommend_Response_Flag,

    OS as Browser_Meta_Info_Operating_System,

    PL as Product_Line,

    "Product Age" as Product_Age,

    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 (Start_Date >'8/31/2017'

AND Start_Date <'10/5/2017')

Please help me with this.

[Gysbert_Wassenaar]

Iirc you need to add # characters around dates if you use ms-access

WHERE (Start_Date > #8/31/2017# AND Start_Date < #10/5/2017# )