>>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
>
>I know I'm entering this thread late, but if you need to pull note fields (which will not convert over to Excel) you can use ODBC via the SQLSTRINGCONNECT() function in VFP. The following code lists the tables,views,etc. in an access database, and included is a function to pull data from a table in an Access database into a VFP cursor, OpenAccessTable()
>
... code sample omitted ...
>-Lou.

Okay, I should proofread my posts before hitting the Send button.
Two things:

1. Yes, I have a bug in the ListAccessTables() function:
Result = SQLTABLES(lnDataSrc, tcWhatKind, tcAlias)
should be:
lnResult = SQLTABLES(lnDataSrc, tcWhatKind, tcAlias)

2. That function name was OpenAccessData() not OpenAccessTable() which would be a better name for it in my opinion...

-Lou.