>I know I don't know much about VFP and DAO/ODBC/etc. But I need the best way to import data from an access data base (mdb) into a foxpro one. I've done some research, what time will allow, but I can't come up with anything. Code would be most helpful. Sorry that I'm so green.
>
From the VFP side, your best bet will be to use ODBC or ADO to open the Access MDB, and read the Access tables record by record, inserting the records into appropriate VFP tables.
On the Access side, you can write the data into xBASE-style tables, which can then be read directly by VFP.