import and rename

[slimjen]

all, using access 2010. I am using the TransferSpreadsheet method to import an excel file into my database. This goes well but I need to know how to rename the tbl I am replacing. Ex. the current table is tblMainFile. I want to have this renamed with the current date attached to it once I import the file into a new table with the same name as the current table:tblMainFile20140702. Can someone please help me out? Thanks

[June7]

Bing: Access VBA rename table

Try this: http://msdn.microsoft.com/en-us/libr...ffice.11).aspx