You could do this:
Set up an access odbc connection and use SPT to get the data into vfp.
This may take 2 steps - get the cursor, then copy the contents into a permanent table. This works pretty fast (maybe down to 1 hour for 5M records) - the COPY TO shouldn't take very long at all, maybe a few minutes for 5M.
e.g.

** assuming ODBC connection called "myaccess"
lnHandle = SQLCONNECT("myaccess")
IF lnHandle > 0
 * good connection
 lnResult = SQLEXEC(lnHandle, "SELECT * FROM table1")
 IF lnResult > 0
   * good - cursor is called "sqlresult"
   SQLMORE(lnHandle)
   COPY TO vfp_table1
 ELSE 
   AERROR(laError)
   DISPLAY MEMORY LIKE laError && or however you want to see it
 ENDIF
 SQLDISCONNECT(lnHandle)
ELSE 
   AERROR(laError)
   DISPLAY MEMORY LIKE laError && or however you want to see it
ENDIF

>I am trying to pull some tables out of Access and into Fox. (This is more of an Access question so I apologize for being out of place.) The tables have several million records and just a few fields but it is taking several hours (3-8) on each. This seems so out of line to me. Any suggestions?
>
>Thanks.