topic Re: DBF File in QlikView

DBF File

upaliwije — Fri, 13 Dec 2013 09:48:02 GMT

I have some data stored in a file with extension .DBF (database file)

Can I import data to Qlikview from that file. If this file type is not allowed how can convert data to file type recognized by Qlikview

Pls someone help me.

Re: DBF File

Eugeny_Ilyin — Fri, 13 Dec 2013 09:51:50 GMT

ODBC, OLEDB ...?

Re: DBF File

Gysbert_Wassenaar — Fri, 13 Dec 2013 10:49:40 GMT

Check that the MS-Access dBASE Driver is installed. If it isn't download the Microsoft Access Database Engine 2010 Redistributable. Next start the ODBC administrator tool odbcad32.exe and add a Data Source. Make sure to select the directory that contains your DBF file. In the screenshot below I've set up a connection to the dbfiles in a directory d:\qvdata\temp.

In the script you then connect using the ODBC data source you just made and then load the data:

ODBC CONNECT TO [Access - dbf];

select * from fox_samp;