Script Error while connecting data from MS Access to Qlikview

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Script Error while connecting data from MS Access to Qlikview

Gysbert_Wassenaar — Thu, 05 Oct 2017 16:26:50 GMT

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