Automatically Changing the Name of an Imported Table

[cyork]

I want to automate a process where the most recently imported table's name is changed to "Example". I was also wondering if it might be possible to save the name of the most recently imported table as a variable.

 

[MichaelRed]

IF (and I do mean IF) all of the imports are done through code, you could create a table for the import files. I would place the Original file name, the import date, the name changed date, and the new name in this table. When the routine went to do an import, get the current "Example" table, change it's name to anything else (but unique within the db) and then do the import to "Example". Altogrther, maybe 20 lines of code.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over