>Ok, my last thread got me nowhere and it seems that no else is getting anywhere with this topic, BUT I need specific examples and I don't need links to Microsoft's ADO site. I know you all are very smart and probably have done something like this. I feel like I can't grasp the meaning of the web sites and/or any documentation I try to find on this subject. Nothing goes into detail.
>
>I am trying to open an access database in VFP 6.0 (C:\GE DESKTOP EDI\EdiPC2). The actual table within the database is called Docfl. I need to select all the records and save them into a new foxpro database. This all needs to be done automatically through VFP not done through ACCESS. This can be done easily, can't it?
>
>Thanks for all your help.

The quick answer to your question is to go to your control panel and look for the ODBC icon. Click on it and set up an ODBC data source for the Access database. Then go into VFP and create (or modify an existing) database. Create a connection to your ODBC data source, then create a remote view using that connection accessing the table Docfl. You can then create a table with that view or whatever you wish to do.

HTH,