MOVING tables to a backup database...

[ineedahelp]

Does anyone have an efficient way to MOVE tables to a backup database using code? Thanks in advance for any help!!

[NeoPa]

Is it an Access database?

[ineedahelp]

Is it an Access database?

Yes, it is an access database.

[NeoPa]

Try this :

SELECT...INTO Statement
Creates a make-table query.

Syntax
SELECT field1[, field2[, ...]] INTO newtable [IN externaldatabas e]
FROM source

The SELECT...INTO statement has these parts:

Part Description
field1, field2 The name of the fields to be copied into the new table.
newtable The name of the table to be created. It must conform to standard naming conventions. If newtable is the same as the name of an existing table, a trappable error occurs.
externaldatabas e The path to an external database. For a description of the path, see the IN clause.
source The name of the existing table from which records are selected. This can be single or multiple tables or a query.

I haven't tried it myself yet but it should work. Let me know if it does.