"too few parameters, expected 5" error when reloading

[#1]

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!

[Chanty4u]

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.

[avinashelite]

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

[awhitfield]

Hi Bo,

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

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

HTH

Andy

[pooja_sn]

Open load script and load data from here: