problem loading dbf files (empty)

[lmonincx]

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?

[Emmanuelle__Bustos]

In my experience to solve this issue is selecting (with the OLEDB connection) the DBF files in their original folder path, I mean do not copy and paste dbf files in other paths where they were originally created (Installed).

Don't know why but its the only way I could read fields of dbf files.

[carolinne88]

Hello , Emmanuelle ! Thanks for the help.
I managed to solve eliminating the single quotes that are in the fields when I make their selection. I was testing many possibilities.
I do not know why this happens, but I was happy to solve .

[Emmanuelle__Bustos]

Oh that is good to know and I keep this solution for in a future using this dbf files.

Regards!