Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import from Access97 (long field names)
Message
From
06/11/2001 11:40:05
 
 
To
06/11/2001 11:31:32
Irv Adams
MSC Managed Care, Inc.
Florida, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00578011
Message ID:
00578034
Views:
21
This message has been marked as a message which has helped to the initial question of the thread.
>I was just trying something simple like the Export feature of Access to a format like Text or Excel, etc. and then trying to draw this in with VFP...worked fine, except for the field names. Guess I'll have to try a more direct approach as you suggested; thanks !

That would export to FP 2.6 format which is for free tables. I think this would be easiest with SQL Pass-through from the VFP side.

The other option would be to use the VFP ODBC driver from the Access side. When you choose the export type, select "ODBC Database" and it will let you select a DSN to a VFP DBC.
Previous
Reply
Map
View

Click here to load this message in the networking platform