Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import Access 2002 tables into Access 97 (2003 or 97)

    We have a database that was created in Access 2002. We need to open the tables in Access 97. There are 19 tables. I realize we can export each table separately, but with 19 tables that need to be updated every week, this is pretty time consuming. I don't know anything about writing code, but I would think someone would know how I can do this task easier than selecting each table in 2002 and File, Export...

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import Access 2002 tables into Access 97 (2003 or 97)

    If you don't want to write code you could use a macro like this.
    Repeat the transferdatabase instruction for each table you want to export.
    Run the macro and all the tables will be exported in one mouse click
    Attached Images Attached Images
    Francois

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import Access 2002 tables into Access 97 (2003 or 97)

    Perfect! That works beautifully. Thank you!

Posting Permissions

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