How to import MS Access Tables into Foxpro V6 1

[ntm0n]

I have tables in MSAccess (Actually converting a program) that I need to get into Foxpro. Some of these tables contain over 2 million rows. Whats the easiest way to accomplish this? What I did to this point is create a query on the access file and then issue a copy statement to a new dbf file.

Next Question: If the above method is the fastest, (The problem with exporting out of access is the field names contain lots of the same names if they are truncated by access and it wont export). How do I now index these tables?

Thanks!

 

[rgbean]

Go to the UTs Download page (

http://www.universalthread.com/Live/Download5.asp),

enter MDB2DBC and then Search. You'll get John Koziol's "Access to VFP Data Migrator".

Rick