Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing a VF DBF file into MS Access
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00426103
Message ID:
00426295
Views:
26
>We are trying to load VF DBF file into MS Access. It is a Visual Basic program issuing the following command line to do this: APPACCESS.docmd.TransferDatabase 0, "ODBC", "ODBC;DSN=Visual FoxPro Tables;SourceDB=" + CurDir() + "\;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;;TABLE=qtrtreat", 0, "QTRTREAT", "QTRTREAT" The DBF file looks ok, but after the transfer, the 1st record in the MS Access table ends up being a combination of 2 or more lines. I don't know what I'm missing that is causing this. Has anyone else experienced this?

Not sure this response is going to help you much - but I think there is a file in the Recent Entries of the Files Section, to do with creating Access MDB's from VFP.

Houston.
censored.
Previous
Reply
Map
View

Click here to load this message in the networking platform