importing tables

[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

 

[John Nurick]

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

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.