Judy,
You can use SQL passthrough to import Access data. Try something like this:

*-- build connection string
lcConnectionStr = "DRIVER={Microsoft Access Driver (*.mdb)};" +;
                  "Dbq=YourDatabase.mdb;" +;
                  "Uid=Admin;" +;
                  "Pwd=;"

*-- connect to MS Access
lnAccess = SQLSTRINGCONNECT(lcConnectionStr)

*-- import Access table into an SPT cursor
SQLEXEC(lnAccess, "SELECT * FROM YourTable") 

HTH
>Is there a way to import data into a Fox table directly from an Access database table, or does it have to be exported into some format from Access first? It doesn't seem to be a choice in the data types for importing.
>
>Judy Scofield