Tables from an MS Access Database into FoxPro 1

[RussA]

Is there an easy way to import tables from an MS Access Database into FoxPro using VFP6 code? I have no problem doing it manually but I would like to automate the process.

Thanks, Russ A =)

 

[rgbean]

Russ,
To get the data converted, start with a utility written by a (now) MS employee that will pull all the data out and put it into tables in a DBC.

It's available on the UT (

http://www.universalthread.com/)

in the Downloads area - look for MDB2DBC - Access to VFP Data Migrator by John Koziol.

Rick

 

[Mike Lewis]

RussA,

You could also do this via ODBC.

Set up an ODBC DSN to point to the Acces database. Create a connection within your VFP DBD to point to the DSN. Then create a remote view based on that connection.

The view will contain all the Access data for a given table. You can then copy that to a normal DBF.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[baltman]

There is a VERY easy way! See the code posted in Thread184-659295 on how to programatically export an Access DB into a VFP DB.

Brian

 

[RussA]

Thanks for the thread Baltman, that is just what I needed. Also thanks to all for the help.

Russ A =)