Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Unanswered: autonumber of imported sessions

    Hi everybody,

    It's been ages since i've used access and i've a question related to importing external data.
    I've a lot of csv files wich should be imported to one table. In this table, i'd like to have one column where I've a "counter" which adds a number to each and every row of the imported data.
    So, when i've a csv file with 10 rows of data and I import it, the counter column in my table should write "001" in all imported rows.
    When I import a second csv file into this table, the counter column should display "002"
    When I import a third csv file.... it should show me "003" for all the data imported...
    Etc...

    Any idea on how I could manage to do this?
    I'd appreciate all suggestions and help!
    thanks a lot already and best regards!

  2. #2
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    119
    You could add a 'Counter' column to your .csv files or if you are using a linked .csv and an append query you could write the required number into the correct field in the query.
    Regards
    JD

    Software-Matters

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •