Import data from .dbf tables (Visual FoxPro)

[#1]

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

Download Microsoft OLE DB Provider for Visual FoxPro 9.0 from Official Microsoft Download Center

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 · Accepted solution]

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]

Hi,

This may work for you

//conexion .dbf

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

LOAD *,
SQL SELECT *
FROM `$`;

[#4]

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

thank you!