Look for MDB2DBC here in the files section.
>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer