transfering data from one database to another 1

[balllian]

What is the best and easiest way to transfer a whole table from one database to another within a macro?? Can i use the transfertext functionality to move the data across??

If this is possible what specification name would i have to give it if at all??

thanks in advance.

 

[PHV]

Have a look at TransferDatabase.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[balllian]

i have entered the following for transferdatabase

Transfer Type: Export
Database Type: Microsoft Access
Database Name: pageviews.mdb
Object Type : Table
Table : Combined
Destination : C:\weblog1\Weblog2\page_views.mdb
Structure Only: No

Is this the correct way to layout what im trying to achieve??

 

[PHV]

No F1 key on your keyboard ?

 

[balllian]

Yes. ive corrected it now to read as follows.

Transfer Type: Export
Database Type: Microsoft Access
Database Name: C:\weblog1\Weblog2\page_views.mdb
Object Type : Table
Table : Combined
Destination : Combined1
Structure Only: No

I wasnt sure if i needed to put the table and the destination info in a different format rather than just name them as i have done.