>Hi,
>
>I'm re-writing an Access app in VFP and I wonder if there's a way to programmatically create .dbfs of all the tables in the database.
>
>I suppose I could run something in VFP *or* in Access... either way, the desired end result would be VFP or FP dbfs.
>
>TIA
You could either export each table in access to a DBF or create remote views in VFP and transfer the data to VFP tables from there. Another alternative is to use ODBC and SQLStringConnect to the MDB and SQLExec to SELECT all the records from tables into cursors. Then transfer the data to VFP tables.
I assume this is a 1 shot data conversion once you go live with the app, so I would not put a whole lot of effort in getting fancy with the transfer of data.
Mark McCasland
Midlothian, TX USA