Results 1 to 8 of 8

Thread: Mass Appending

  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mass Appending

    I am using Access 97 and have about 250 tables that I need to append into one table. They all have the same headings which may make things easier.
    I know how to do this in DOS therefore, I am trying to work out how to either, export as ASCII text files, all in one go, or how to append the tables all in one go.

    I have little VB experience and all but given up trying to find a method using a standard query.
    Any help or a push in the right direction would be much appreciated.

  2. #2
    DAW
    Guest

    Re: Mass Appending

    Check out Union Queries in the Access help. I think this will help you - if I have understood your requirement properly.

    Dave.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mass Appending

    Thanks for the tip, i'll have a read through.

    Thats the thing with Help, you have to know the correct words to type in.

  4. #4
    Lounger
    Join Date
    Feb 2001
    Location
    TX, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mass Appending

    One answer would be to export all of the tables to be combined to a separate mdb. Then link those tables to the main db. Loop thru the tables collection and, if the Connect property is >0 then run an append query to move the data into the combinedTable. Delete that linked table and continue with the next until the data is all combined.

    HTH
    Jim

  5. #5
    DAW
    Guest

    Re: Mass Appending

    I have just noticed that you said there were 250 tables!
    Jim's solution is better than my suggestion re. Union queries. Sorry for misleading you.

    Dave.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Mass Appending

    On minor correction. The connect property is a string. So it will either have a length > 0 or will be "", but it will never actually be >0.
    Charlotte

  7. #7
    Lounger
    Join Date
    Feb 2001
    Location
    TX, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mass Appending

    you're right. forgot.

  8. #8
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mass Appending

    Thanks for all of your help, I ended up using a Union query which worked very well with a little help from copy & paste.

Posting Permissions

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