Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reading an MDB file from VFP
Message
 
To
31/05/2003 15:39:53
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00794718
Message ID:
00795186
Views:
14
Well it's like a one time thing. I received the MDB file via email. I can read it using Access fine.Is it possible to just export it to a dbf using Access?

>>I have a MDB file and want to "access" it thru my vfp. Can I do this or must I convert the file from within Access so that VFP can read it?
>
>Hi Tim,
>
>Besides the connection string and SQL Pass-through method that Yuri and JC mentioned, you can set up a named ODBC data source, create a vFP DBC, then add a connection to your data source and create remote views to your MDB. Then you can use the views in much the same way as VFP tables. You can also skip the data source and set up your connection with a connection string (use the Connection Designer). Read the client-server sections in the VFP Help.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
Previous
Reply
Map
View

Click here to load this message in the networking platform