How to rename table referencing DateUpdate field

[BridgestoneGal]

Please tell me how to rename a Table (in a way that can be run from a Macro) to incorporate the DateUpdate field.

I would ideally like to append the current Month to a table name as it is being imported.

Thanks!

 

[coco86]

You can do this using code

DoCmd.TransferDatabase acImport, DatabaseType, DatabaseName, acTable, SourceTable, NewTableName & Format(Date, "mmddyy")

If you absolutely need to run it from a macro then create a function in a module like this

Public Function ImportTable()
    DoCmd.TransferDatabase acImport, DatabaseType, DatabaseName, acTable, SourceTable, NewTableName & Format(Date, "mmddyy")
End Function

and then in your macro use the action "RunCode" and "ImportTable()" as the function name.


-Coco

 

[BridgestoneGal]

Thanks for the tip Coco!