importing tables

  • Thread starter Thread starter ben
  • Start date Start date
B

ben

I am trying to import tables into a db and append them to
a table in that db. I have the tables imported, and i
can append most of the records, but there is a IDnumber
field that have identical numbers (and they need to be
unique)...is there a way to programmatically add numbers
to the old IDnumbers? Such as changing 101 to 99999101?

ben
 
Hi Ben,

You could use a calculated field in your Append query:

NewID: [IDNumber] + 90000000

and of course append this to the IDNumber field in the "permanent"
table. If there are related records in other tables you're importing,
you'll have to update the relevant field in these accordingly, of
course.

I am trying to import tables into a db and append them to
a table in that db. I have the tables imported, and i
can append most of the records, but there is a IDnumber
field that have identical numbers (and they need to be
unique)...is there a way to programmatically add numbers
to the old IDnumbers? Such as changing 101 to 99999101?

ben
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top