topic Re: load accdb in QlikView

load accdb

Anonymous — Sun, 14 Aug 2016 11:59:20 GMT

hi,

is it possible to load access fiels (accdb) ?

orders1.accdb

orders2.accdb

...

i don't have access to the DB i only have those files - like xls...

thanks'

yarin.

kaushiknsolanki — Sun, 14 Aug 2016 12:04:26 GMT

Hi,

Yes you can do that provided you have the proper ODBC Driver installed.

Generally it gets installed when you install MS OFFICE suit.

Create ODBC Connection to accdb and then use that connection to load data in QlikView.

Regards,

Kaushik Solanki

trdandamudi — Sun, 14 Aug 2016 12:30:08 GMT

It is possible to load the data from Access database. Please follow the below instructions for Qlikview:

step 1: SELECT "OLE DB " in the Database tab

step2: Check "force 32 Bit"

step3: Click "Connect"

step4: in the "Data Link Properties ". Select "Microsoft Office 12.0 Access Database Engine OLEDB Provider"

step5: Click "Next"

step6: You will be directed to "Connection Tab"

step7: Copy and paste the complete/full path of the Access Database ("C\Temp\yourDatabase.accdb")

step8: Go to "Advanced tab", uncheck "Share Deny None" and Check "Read/Write"

step9: Go to "Connection tab" and click "Test Connection"

step10: then you will have a message : "Test Connection succeeded"

step11: Click "OK"

Now to select the fields from a particular table click on Select button and select the table and the fields you need and also put a check against

Preceding Load so that you can see the list of fields and then click ok.

I am also attaching a sample .qvw file for your reference. Hope this helps....