Rename Tables when importing data from as400

[Guest]

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"

 

[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 (e-mail address removed)> wrote in message
news:[email protected]...