By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,064 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,064 IT Pros & Developers. It's quick & easy.

Transaction Number addition to Imported Data

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.