Exporting/Importing

[Jason]

I have a database that has been split into a front end and a back end. I wish to export a table from the front end into another seperate database without it creating a link table to the back end. I have used the copyobject and transferdatabase commands to copy the table into another database but because the table is linked (because of the back end split) it automatically creats a linked table in the new database. The new database is then sent to another user not on the network and of course it can't link to the table. I'm trying to do this so the user just clicks a button and a new database is created with the table included and they can then just e-mail it out.

 

[John Nurick]

Hi Jason,

One way to do this is by first creating the new mdb file and then
building and executing the SQL for a make table query, using the syntax

SELECT field1[, field2[, ...]]
INTO newtable [IN externaldatabase]
FROM source

The only way I know to find the help on this is to start in the main
Access window, go to Help|Contents, and then in the contents list work
your way through: Microsoft Jet SQL Reference, Data Manipulation
Language, SELECT...INTO