topic "too few parameters, expected 5" error when reloading in QlikView

"too few parameters, expected 5" error when reloading

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I met a problem when reloading. There is a "too few parameters, expected 5" error, I tried some ways to solve this problem, like change the name "Date" in access into "As Of Date", change all "-" in the name to "_" but this error still existed. Here is my reloading code:

ODBC CONNECT TO [MS Access Database;DBQ=C:\Users\xx\Desktop\xx\xx_test.accdb];

LOAD [As Of Date],

[bankname];

SQL SELECT *

FROM compare;

BTW, all queries in my access run well without error, and I certainly have both "As Of Date" and "bankname" in query "compare".

Thanks a lot!

Re: "too few parameters, expected 5" error when reloading

Chanty4u — Thu, 17 Mar 2016 12:20:30 GMT

debug ur code once...

or else ry to create sample qvw with the part of the data which u got the error?

and try to reload again.

Re: "too few parameters, expected 5" error when reloading

avinashelite — Thu, 17 Mar 2016 12:39:04 GMT

As per my knowledge it s the issue with the driver not with Qlikview ....check the driver connection once

Re: "too few parameters, expected 5" error when reloading

awhitfield — Thu, 17 Mar 2016 12:43:29 GMT

Hi Bo,

that's an Access error, check out the following:

https://support.microsoft.com/en-us/kb/171850

HTH

Andy

Re: "too few parameters, expected 5" error when reloading

pooja_sn — Thu, 17 Mar 2016 13:22:27 GMT

Open load script and load data from here: