Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Automatically Changing the Name of an Imported Table
- Thread starter cyork
- Start date
MichaelRed
Programmer
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
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
- Status
Similar threads
- Locked
- Question
- Locked
- Question