Trouble loading data from MS Access

[#1]

I have data in an MS Access file I want to load. I downloaded and configured the ODBC driver and can see my tables in Qlik, but when I select a table nothing shows up in the data preview area.  Suggestion on what I'm doing wrong?

[beck_bakytbek · Accepted solution]

Hi Kris,

i think, all depends on your Access.format. do you use mdb or accdb format.

check this: Problems connecting to ODBC

i am sure you can solve your problem if you read this part of topic,

if you need more assistance, let me just know

beck

[#3]

Problem solved.  Thanks!!

[beck_bakytbek]

Hi Kris,

How did you solve your Problem, what caused your Problem

thanks

beck

[#5]

Hi Beck,

I was able to use the info in the thread you directed me to about ‘problems connecting to ODBC’.  I don’t know if I have a newer version of Qlik or what as the directions were not step by step, but I was able to sort it out from the info provided.  I think it was a format issue – I was trying to connect to a MdB.

Kris

[beck_bakytbek]

OK, Kris it does sound great, if provided info has helped you, you can mark as correct, so that another collegues can find necessary information to this issue on the base of your marks

[#7]

Will do.