Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
As per my knowledge it s the issue with the driver not with Qlikview ....check the driver connection once
Hi Bo,
that's an Access error, check out the following:
https://support.microsoft.com/en-us/kb/171850
HTH
Andy