Export Table to New Database

[Taff]

Hi all,

Am having some real trouble trying to work out how to do this but I'm sure it's really simple.

What I am trying to do is Export the table mytable to a completely new database which would be stored in the same location as the current database.

Any help is greatly appreciated.

Taff.

 

[Taff]

Hi Pat,

Have tried the transferdatabase method but for some reason it does not seem to be working.

A couple of questions with it:-

Does the database you are trying to export to have to exist already when trying to use it?

If so, does the table have to exist in the database?

Taff.

 

[Taff]

Thanks again Pat.

Taff.