Help needed - Importing a table from on DB to another

  • Thread starter Thread starter FatMan
  • Start date Start date
F

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
 
FatMan said:
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.
Click to expand...


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