>I am trying to create the access DB and add the data to a table within that access database within the foxpro program. Any ideas?
You can do it via ODBC. From Access, using the VFP ODBC driver, or from VFP, using Access'.
From VFP is just as easy as creating the DataSource (in the ODBC control panel), and then using SQLConnect(
), and SQLExec( , ).
Take a look at the help file on this two functions and you'll be doing it in a matter of minutes.
Good luck.