topic problem loading dbf files (empty) in QlikView

problem loading dbf files (empty)

lmonincx — Tue, 01 Sep 2009 21:26:08 GMT

Hi I try to load a dbf file, i used odbc Microsoft Access dBase driver for *dbf files, with other dbf files this worked but for some reason using this dbf file the content is empty when i use the select function in the script after the connection is setup.

If i load it in msaccess i get the data, why not in QV?

Any idea?

problem loading dbf files (empty)

Tue, 01 Sep 2009 22:48:14 GMT

I was having the same problems with dbf ...

Are you using the Microsoft Access dbase-driver?

Which messages are you receiving?

Best regards
Stefan WALTHER

problem loading dbf files (empty)

lmonincx — Thu, 03 Sep 2009 15:32:14 GMT

Hi Stefan,

I used the Microsoft Access Dbase driver, this worked with some older dbf files, but with this new file I am able to connect through the odbc connectie but when i click on select and the window from QV opens I can see the dbf file but the fields are not listed, it's only having the *, when clicking on OK the error below appears:

SQL Error:[Microsoft][ODBC dBASE-stuurprogramma] De Microsoft Office Access-database-engine kan het object DBFTAB_hypotheek niet vinden. Zorg ervoor dat het object bestaat en dat u de naam en het pad correct hebt gespeld.
SQL Scriptline:
SQL State:S0002
SQL SELECT *
FROM `C:\DOCUMENTS AND SETTINGS\LINDA MONINCX\BUREAUBLAD`\`DBFTAB_hypotheek`

It's saying that it can't find the object/dbf file.

is this simular with your problem?

Regards, Linda

problem loading dbf files (empty)

Anonymous — Thu, 03 Sep 2009 19:18:31 GMT

I access dbf files using the visual foxpro driver (that I think is the best solution) and all work well and should works with all version of dbf files.

The driver is downlodable from microsoft sites

You first have to create the odbc connection in control panel and the use it in the script.

Hope can be helpful.

Luca C.

problem loading dbf files (empty)

lmonincx — Fri, 04 Sep 2009 15:16:26 GMT

Hi, I tried the Visual Fox Pro as well but without result. The strange thing is that when i access through MS Access I get the data incl fields and content (data) but wihtin Qlikview nothing.

Linda

problem loading dbf files (empty)

Anonymous — Fri, 04 Sep 2009 16:16:46 GMT

hi, could you attach your files so i will make a test in my environment ?

Bye

Luca C.

problem loading dbf files (empty)

lmonincx — Fri, 04 Sep 2009 17:25:03 GMT

I am not able to upload a dbf file through this portal, can you provide me your email, mine is lmonincx@oneline.nl

Thanks for the help!

Linda

problem loading dbf files (empty)

Mon, 07 Sep 2009 19:01:44 GMT


LMonincx wrote:
Hi Stefan,
I used the Microsoft Access Dbase driver, this worked with some older dbf files, but with this new file I am able to connect through the odbc connectie but when i click on select and the window from QV opens I can see the dbf file but the fields are not listed, it's only having the *, when clicking on OK the error below appears:
SQL Error:[Microsoft][ODBC dBASE-stuurprogramma] De Microsoft Office Access-database-engine kan het object DBFTAB_hypotheek niet vinden. Zorg ervoor dat het object bestaat en dat u de naam en het pad correct hebt gespeld.
SQL Scriptline:
SQL State:S0002
SQL SELECT *
FROM `C:\DOCUMENTS AND SETTINGS\LINDA MONINCX\BUREAUBLAD`\`DBFTAB_hypotheek`
It's saying that it can't find the object/dbf file.
is this simular with your problem?
Regards, Linda<div></div>

... no unfortunately I had a completely different problem ...

Best regards

Stefan

problem loading dbf files (empty)

Mon, 07 Sep 2009 19:10:42 GMT

How are you trying to connect to the dbase-files?

I was only able to create a DSN ...
Then try to play with the DNS-option "Show deleted rows" ... this solved my problems ...

Best regards
Stefan

problem loading dbf files (empty)

Fri, 12 Mar 2010 05:25:23 GMT

Hi All,

Can anybody send me the set of steps to load the DBF files into qlikview. I want the steps for both the scenario. i,e what steps should be followed if dbf driver is available in my system and what steps has to be followed if dbf files are not available in the system.

Thanks and Regards,

Rikab

problem loading dbf files (empty)

Fri, 12 Mar 2010 08:24:21 GMT

Hi All,

Got succeeded by using the following steps!

Start --> Settings --> Control panel --> Administrative tools --> Data sources -->System DSN --> Add --> Microsoft dBase Driver(*.dbf) --> Enter the data source name and description that you prefer --> Uncheck the "use current directory --> select directory --> chosse the path where data is located --> ok-->ok --> click reload in the qlikview --> select --> Select the data source that you have created -- select the required table--> ok

After following the above steps I am able to load the data.

Thanks and Regards,

Rikab

Re: problem loading dbf files (empty)

Thu, 08 Mar 2012 14:45:39 GMT

please assist, i followed the steps but get the following error:

'the microsoft jet engine could not find the object.'

in QV, the table information preview does not show any rows.

problem loading dbf files (empty)

Emmanuelle__Bustos — Wed, 28 Mar 2012 00:02:51 GMT

Hello everyone

Having the same issue and trying a lot of things i finally could find that the driver needed is the "Driver do Microsoft Visual Fox Pro" BUT you should specify when create the DSN that there are Tables instead of BD and set the directory where the files .bdf are stored, so you can create the connection with QV using that DSN.

Re: problem loading dbf files (empty)

agigliotti — Thu, 27 Feb 2014 17:06:45 GMT

I'm able to connect using ODBC driver 32 bit but I can't see any tables from the list.

Can you help me?

Thanks.

Regards

Re: problem loading dbf files (empty)

Emmanuelle__Bustos — Thu, 27 Feb 2014 17:37:00 GMT

Hi Andrea

Please make sure to use the OLEDB instead ODBC this was the only way to get connected successfully after to many tries.

Use the Driver "Microsoft Visual Fox Pro":

Re: problem loading dbf files (empty)

agigliotti — Mon, 03 Mar 2014 09:19:29 GMT

Hi Emmanuelle,

below the OLE DB settings:

I don't have a .DBC file but only .DBF, .CDX e .FPT

The "TEST CONNECTION" works successfully , but when I press the button "SELECT..." inside QV Desktop I get an EMPTY database tables list as using ODBC driver.

Can you help me?

Many Thanks

Re: problem loading dbf files (empty)

agigliotti — Mon, 03 Mar 2014 09:45:00 GMT

I have Microsoft Access dBASE Driver in drivers list.

I have to use it ?

Re: problem loading dbf files (empty)

agigliotti — Mon, 03 Mar 2014 10:00:48 GMT

Hi,

I attached the DBF file in this thread.

Can you make a test in your environment ?

Many thanks.

Re: problem loading dbf files (empty)

agigliotti — Mon, 03 Mar 2014 10:03:07 GMT

Hi Linda,

Did you solve the problem?

I have dbf file (Visual Fox Pro 9) that I can't read either in MS ACCESS and QLIKVIEW.

Attached the DBF file.

Please take a look.

Thanks

Regards

Re: problem loading dbf files (empty)

carolinne88 — Fri, 03 Jul 2015 11:06:55 GMT

Hello!

I have problems with loading dbf. files. I need help.

I'm using the Visual FoxPro. Fields's connection e selection are ok, but when I load the QlikView file , it does not find the fields selected.