topic Load data from ".dbf" files in QlikView

Load data from ".dbf" files

Wed, 04 Mar 2015 13:27:31 GMT

Hi ,

I need to load tables which are ".dbf" files and I ' m not able to understand the wizard to do so,

Edit script --> DATABASE --> Connect ... and I get lost, I do not know what else to do.

The files are local, can anyone tell me the way to load them or a piece of a sample script?

Thank you

Re: Load data from ".dbf" files

Alejandro_Hernández — Wed, 04 Mar 2015 14:22:21 GMT

Setup an ODBC connection to your dbf file:

then connect to that in Qlikview.

Re: Load data from ".dbf" files

Wed, 04 Mar 2015 16:16:37 GMT

Thank you but I d'ont understand.

Re: Load data from ".dbf" files

Alejandro_Hernández — Wed, 04 Mar 2015 17:23:13 GMT

first step, go to control panel-administrative tools.

then go to the ODBC Data Sources (32-bit)

click on system dsn tab and click on add.

from the create new data source list, select microsoft dbase driver

type a name for the DSN e.g. "QV_DBF"

configure directory and indexes. click OK when done.

then in Qlikview, in edit script screen, in data tab select ODBC from the list.

click connect and from the datasource list, select the dsn you created (e.g. QV_DBF) and click ok.

then click Select and select the fields you want to import from your DBF.

Re: Load data from ".dbf" files

Wed, 04 Mar 2015 18:02:18 GMT

Sorry but I do not see any "system dsn tab" so from this point I can't continue your kind steps, maybe I have an old release, If you do not mind I attached a simple 'file.dbf' so you can try to connect to it and I could see the resulting script

Thanks

Re: Load data from ".dbf" files

Mon, 23 Mar 2015 09:31:29 GMT

Hi Luis,

Type C:\Windows\SysWOW64\odbcad32.exe at the command prompt. That should open the ODBC Data Sources (32-bit) and allow you to configure the System DSN.

Cheers