Transaction Number addition to Imported Data

[John Baker]

Hi:

Having a little problem here. I am importing data from Excel, using a macro, and importing
it into a previously defined table. I wish to immediately add a transaction number to each
record, and am having a little trouble doing it. I cant set the file up with an TN because
then it does not match the import data format. If I use a query to add one, i have trouble
setting up a constant incremented number (maybe there is a way and someone can tell me),
so I am interested in how others have solved similar problems.

Regards

John Baker

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Import the Excel data into a temp table (the column data types are all
Text). Do data cleaning on the temp table & then append that data
into the production table that has an AutoNumber column as the TN
column.

For more info see the Access help articles on AutoNumber columns.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP/DX2YechKqOuFEgEQLoVgCdFuWDJeQHm9NuZ7o7rzFW2SzxZ2EA oMxe
SKcgp3MYag6qnRWdbUKoR+0s
=hWSs
-----END PGP SIGNATURE-----
John Baker wrote:

Hi:

Having a little problem here. I am importing data from Excel, using a macro, and importing
it into a previously defined table. I wish to immediately add a transaction number to each
record, and am having a little trouble doing it. I cant set the file up with an TN because
then it does not match the import data format. If I use a query to add one, i have trouble
setting up a constant incremented number (maybe there is a way and someone can tell me),
so I am interested in how others have solved similar problems.

Regards

John Baker