Dave,
There are different ways to do this. The following code uses SQL-passthrough:
*-- build connection string
lcConnectionStr = "DRIVER={Microsoft Access Driver (*.mdb)};" +;
"Dbq=c:\temp\bidon.mdb;" +;
"Uid=Admin;" +;
"Pwd=;"
*-- connect to MS Access
lnAccess = SQLSTRINGCONNECT(lcConnectionStr)
*-- create the table
*-- Note that we need to use Access SQL dialect (char(12) vs. C(12))
SQLEXEC(lnAccess, "CREATE TABLE test (Type char(12), id char(12))")
*-- select some data
SELECT type, id FROM HOME()+"foxuser" INTO CURSOR test
*-- insert the result set into MS Access
WAIT WINDOW NOWAIT "Inserting data into MS Access..."
SCAN
SQLEXEC(lnAccess, "INSERT INTO test VALUES('" + Type + "', '"+id+"')")
ENDSCAN
Daniel