Load data from ".dbf" files

[#1]

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

[Alejandro_Hernández · Accepted solution]

Setup an ODBC connection to your dbf file:

then connect to that in Qlikview.

[#3]

Thank you but I d'ont understand.

[Alejandro_Hernández]

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.

[#5]

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

[#6]

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