Hey @ all,
i have a problem with a table witch is exportet from access.
1) i started with this table in excel
2) i load this table in access
3) without to do something with the table i export the table back to excel
I can see no difference between the tables 1) and 3)
4) now i want to load the table in Qlik Sense
and i can see the last entry is wrong.
Why is there a problem with the sign '&'? Are there similar problems with other signs and
how can i avoid?
best regrads, rico
There definitely something weird about that exported file as I get the same issue as you, but also in Qlikview as well as sense.
Also if you simply re save the access produced file in excel, it seems to work fine!
Can you export from Access to CSV (p.s. I have never used ACCESS)