Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Convert access to foxpro? 1
- Thread starter sdmi
- Start date
Bonjour.
You can export data from Access to Fox. To do that, just open your database DB in Access, choose File, Save as/Export and in the type Box, choose Fox (2.6 or 3.0) and click on OK.
If you don't have Access (only the DB), in Foxpro you can create a connection to that Database (in a Fox DBC) and create a remote view that is connected with the table you want. Then, you use the view (alway's in Fox) and issue ;
COPY TO tbl1
It will convert the Access table into Fox table.
You can also use the remote view to use and manipulate the Access data from Fox. The data stays in Access form , but it's accessed by fox. The best of both words.
Hope that help.
Salut !
You can export data from Access to Fox. To do that, just open your database DB in Access, choose File, Save as/Export and in the type Box, choose Fox (2.6 or 3.0) and click on OK.
If you don't have Access (only the DB), in Foxpro you can create a connection to that Database (in a Fox DBC) and create a remote view that is connected with the table you want. Then, you use the view (alway's in Fox) and issue ;
COPY TO tbl1
It will convert the Access table into Fox table.
You can also use the remote view to use and manipulate the Access data from Fox. The data stays in Access form , but it's accessed by fox. The best of both words.
Hope that help.
Salut !
-
1
- #3
Go to the FoxPro UT ( then click on the Downloads Link. Next enter MDB in the Title box and press enter. You should get back "MDB2DBC - Access to VFP Data Migrator", this may be what you are looking for (and it's FREE.
Rick
Rick
- Status