Hi John,

I need to make a correction to my earlier statements. The SQL to use
should actually be a SELECT INTO statement. eg/

SELECT *
INTO [PathToMdb].[TargetTable]
FROM [LocalTableName]
WHERE conditions.......

The Frog

It is now working. I can pass record details in any language from an
Access db to another Access db. The procedure is as follows:
EXPORT
1) Click on an Export button which opens up a form asking for the
pathname of the mdb or mde to be created.
2) Create the mdb using CreateDatabase(strFullPathname,
"tblCustomerIE") This creates the db from scratch with the required
fields.
3) Create the link to the mdb and copy the values of the fields you
want.

IMPORT
1) Click on an Import button which opens up a form asking for the
pathname of the mdb file.
2) Create the link to the mdb.
3) Copy the required fields

Thanks to all and happy Thanksgiving,
John