topic problem with table exported from access in App Development

problem with table exported from access

Mon, 27 Apr 2015 07:39:10 GMT

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

Re: problem with table exported from access

awhitfield — Mon, 27 Apr 2015 08:58:47 GMT

Hi Rico,

What's your load script?

Andy.

Re: problem with table exported from access

awhitfield — Mon, 27 Apr 2015 09:03:29 GMT

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

Re: problem with table exported from access

Mon, 27 Apr 2015 09:03:40 GMT

hi andy,

what do you mean with "load script"??

rico

Re: problem with table exported from access

Mon, 27 Apr 2015 09:04:38 GMT

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

Re: problem with table exported from access

awhitfield — Mon, 27 Apr 2015 09:30:32 GMT

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

Andy

Re: problem with table exported from access

Mon, 27 Apr 2015 10:42:27 GMT

here you can see the data load editor

Re: problem with table exported from access

awhitfield — Mon, 27 Apr 2015 13:08:42 GMT

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

Andy

Re: problem with table exported from access

Mon, 27 Apr 2015 13:13:44 GMT

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

best regards rico

Re: problem with table exported from access

awhitfield — Mon, 27 Apr 2015 14:14:31 GMT

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

Re: problem with table exported from access

Tue, 28 Apr 2015 10:48:37 GMT

hi andy,

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

but this is not a smart solution 😉

Re: problem with table exported from access

awhitfield — Tue, 28 Apr 2015 14:01:57 GMT

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