Unique ID system and multiple data sources

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I was given a database that has unique IDs for each record such as:

AL00001
AL00002
AL00003
etc

The trouble is, I'm going to need to import data from another source that
will also have IDs such as this and more than likely there are going to be
duplicates. So if I import data that already has an AL00003, how can I get
access to automatically read the table and figure out the latest ID and then
bump it up or update from AL00003 to AL00004?

In this same field the IDs can be anything like AL00001, or CA00001 so I
also want to look at those first two characters and then figure out the max
num thats in the field.

Make sense? I'd like to setup an import query, then run this unique ID/dup
check/update function, then append those temp records into the main table.
Thank you in advance!
 
If i were you, i would use Access code (VBA) to do it

Edmun
MCP - Access and SQL Serve

----- Jason wrote: ----

I was given a database that has unique IDs for each record such as

AL0000
AL0000
AL0000
et

The trouble is, I'm going to need to import data from another source tha
will also have IDs such as this and more than likely there are going to b
duplicates. So if I import data that already has an AL00003, how can I ge
access to automatically read the table and figure out the latest ID and the
bump it up or update from AL00003 to AL00004

In this same field the IDs can be anything like AL00001, or CA00001 so
also want to look at those first two characters and then figure out the ma
num thats in the field

Make sense? I'd like to setup an import query, then run this unique ID/du
check/update function, then append those temp records into the main table
Thank you in advance
 
Back
Top