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?
Thanks.

0
edit delete
are you sure?
asked Klueze

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/

0
edit delete
are you sure?
answered Krzysztof Spaliński

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions