I never used, it but you could try out "MDB2DBC - Access to VFP Data Migrator" in the files section. This will get the data into VFP, then it is easier to manipulate. Or you could look at the code and get some ideas on how to do it yourself.

I've used John's other utility DBC2MDB tons of times and it works great.

>I’m converting an Access database application into a VFP6.0 application. I need to convert the Access data to a VFP database container containing several VFP tables. I already have the VFP application running and the VFP tables created. I now need to write the conversion program that will read the Access data into the VFP tables. I am wondering what is the best route to take on this. I’m thinking that I would dump the Access data into an Excel Spreadsheet and then use the APPEND FROM command to pull that data into a Foxpro table? I would then use this Foxpro table (and the various Foxpro data manipulation commands) to import the data to the VFP database that supports the new VFP application. This is basically the route I use to use when importing data into Foxpro 2.X applications. Is this the best route to take in VFP6.0? Is there a better option? Perhaps Access to XML and then XML to the Foxpro tables?
>
>Thanks, David