Loading dbf Foxpro file from Excel VBA Project

Hi there:
I’m trying to load a dbf file generated from Foxpro7 into Excel (programmatically), I don’t want to use any export/import mechanisms because the objective is to carry out this transparently for the user. Is there any way of doing this using VBA without using any external tool and compatible for x86 and x64 platforms?

1 answer

Hello Klueze,

try use solution from: https://stackoverflow.com/questions/45224761/viewing-dbf-file-visual-foxpro-9.

You can do export by using shell in VBA to execute command in Visual FoxPro command window (for exemple: https://www.myonlinetraininghub.com/vba-shell)

If you export sucesfully data to .csv or .xls file do standard connection for those files.

You can use simply connection string: https://www.connectionstrings.com/dbf-foxpro/