>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.

Create an ODBC connection into the Access MDB.
Create a database in VFP and add a Connection using this ODBC connection.
e.g., assuming an ODBC connection named "myAccessODBC"

CREATE DATABASE vfp2access
** pull up the Connection Designer to put in the connection info
CREATE CONNECTION connAccess

Create a remote view in this database into the Access table.

CREATE SQL VIEW rvDocfl REMOTE CONNECT connAccess AS ;
SELECT * FROM Docfl

USE the remote view.
COPY TO the VFP table using the DATABASE argument to put the table into the above database. I recommend this to make sure any long field names get preserved.


OPEN DATABASE vfp2access
USE rvDocfl
COPY TO vfpDocfl DATABASE vfp2access