topic Re: Import data from .dbf tables (Visual FoxPro) in QlikView

Import data from .dbf tables (Visual FoxPro)

Tue, 30 May 2017 07:30:52 GMT

Hi everyone,

i want to import data from some Visual Foxpro tables (.dbf files) into Qlikview 12, but i can't do that.

I've follow some tutorial, i've added visual foxpro ole db provider that i've downloaded there

I've used it to connect to the folder that contains my .dbf tables, but qlikview doesn't import my data.

How can i manage it to work, if it is possible?

Thank you.

daveamz — Tue, 30 May 2017 09:25:10 GMT

Hi Mauro,

I've used the same connector, this are the steps:

1. Select 'OLE DB'

2. Select 'Force 32 Bit' -> if I'm not mistaken, this is mandatory for Fox.

3. Select 'Microsoft OLE DB Provider for Visual FoxPro' -> Next

4. 'Select or enter a database name' -> Expand

5. Select 'Free Table directory' -> Browse for your DBF file.

Here is a very ugly guide (powered by MS Paint):

Regards,

David

el_aprendiz111 — Tue, 30 May 2017 14:39:24 GMT

Hi,

This may work for you

//conexion .dbf

ODBC CONNECT32 TO [Visual FoxPro Database;DBQ=C:\USERS\YOUUSER\DOCUMENTS\forlder];

LOAD *,
SQL SELECT *
FROM `$`;

Tue, 30 May 2017 15:21:32 GMT

that's what i've done after posting this question and it worked!

thank you!