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