Help needed - Importing a table from on DB to another

[FatMan]

Hi all:
Can anyone tell me what the code is to import a table form one database to
another database? I would also like to append the system time (time only and
not the date) to the orginal name in the second database. For example:
OrginalName becomse OriginalName0800 if the table was imported at 8:00 a.m.

Any help would be greatly appreciated.

Thanks,
FatMan

 

[Dirk Goldgar]

Hi all:
Can anyone tell me what the code is to import a table form one database to
another database? I would also like to append the system time (time only
and
not the date) to the orginal name in the second database. For example:
OrginalName becomse OriginalName0800 if the table was imported at 8:00
a.m.

DoCmd.TransferDatabase _
acImport, _
"Microsoft Access", _
"C:\Path\To\SourceDB.mdb", _
acTable, _
"OriginalName", _
"OriginalName" & Format(Time, "hhnn")