Rename Tables when importing data from as400

  • Thread starter Renaming tables prior to as400 data tran
  • Start date
R

Renaming tables prior to as400 data tran

We have a db that we use som vb cose to import data from an as400 query into
a table in access. When we import if the tabls "customer" is already in the
db it will rename it o "customer1" and so on. Is there a way to rename the
table prior to impporting the data? EX. if the table name is "customer wk1"
and now after importing the fresh data there will also be a table named
"customer wk2"
 
D

Douglas J. Steele

CurrentDb().TableDefs("customer wk1").Name = "customer wk2"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



"Renaming tables prior to as400 data tran" <Renaming tables prior to as400
data [email protected]> wrote in message
news:[email protected]...
 
Top