problem with table exported from access

[#1]

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

[#2]

hi andy,

export the table to csv and convert into xlsx works well.

but this is not a smart solution 😉

[awhitfield]

HI Rico,

why not load it directly from the csv rather than converting in to excel? That would save time and effort, and it would be less prone to oddities, like this!

Andy