Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

problem with table exported from access

Hey @ all,

i have a problem with a table witch is exportet from access.

1)  i started with this table in excel

pic10.PNG

2) i load this table in access

pic11.PNG

3) without to do something with the table i export the table back to excel

pic12.PNG

I can see no difference between the tables 1) and 3)

4) now i want to load the table in Qlik Sense

pic13.PNG

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

11 Replies
awhitfield
Esteemed Contributor

Re: problem with table exported from access

Hi Rico,

What's your load script?

Andy.

awhitfield
Esteemed Contributor

Re: problem with table exported from access

Does it work if you load directly from the initial xlsx?

Not applicable

Re: problem with table exported from access

hi andy,

what do you mean with "load script"??

rico

Not applicable

Re: problem with table exported from access

it works very well if i load directly from the initial file.

awhitfield
Esteemed Contributor

Re: problem with table exported from access

Qlik on 'Data Load Editor' and there will be a tab showing you what the load script is.

Andy

Not applicable

Re: problem with table exported from access

here you can see the data load editor

pic14.PNG

awhitfield
Esteemed Contributor

Re: problem with table exported from access

That looks fine, can you post the two version of the xlsx?

Andy

Not applicable

Re: problem with table exported from access

the initial file is called test.xlsx and the exportet file is called Tabelle1.xlsx

best regards rico

awhitfield
Esteemed Contributor

Re: problem with table exported from access

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)

Andy