topic Trouble loading data from MS Access in QlikView

Trouble loading data from MS Access

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Trouble loading data from MS Access

beck_bakytbek — Thu, 11 Aug 2016 22:04:35 GMT

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

Re: Trouble loading data from MS Access

Wed, 17 Aug 2016 21:14:10 GMT

Problem solved. Thanks!!

Re: Trouble loading data from MS Access

beck_bakytbek — Thu, 18 Aug 2016 08:36:09 GMT

Hi Kris,

How did you solve your Problem, what caused your Problem

thanks

beck

Re: Trouble loading data from MS Access

Thu, 18 Aug 2016 15:59:06 GMT

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

Re: Trouble loading data from MS Access

beck_bakytbek — Thu, 18 Aug 2016 19:22:21 GMT

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

Re: Trouble loading data from MS Access

Thu, 18 Aug 2016 19:32:07 GMT

Will do.