>I have access to FoxPro 3.0 and 6.0 and can use either one for this. I'd like to be able to do this programmatically without any manual messing around. A suggestion that will work from the Access side is fine as well, but the methods I have discovered there do not work well at all.
>
>Any suggestions?
If this is a 1 shot deal, why can't you just import it from the Access side? I just click on NEW under the table tab, and click Import. Specify that this is a FoxPro table [dbf], select the table and go.
If this is going to be an Access table that others will use from Access and you need to use it from VFP, you can create a remote view of the Access table using ODBC. You can make this view updatable and retrieve data from Access and send back updates and new records with little or no problems.
Mark McCasland
Midlothian, TX USA