Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exporting Tables (Access 2000 - 2003)

    Hello,

    I am wondering whether it is possible to export a group of tables from Database 1 to Database 2 and do this in the one action (eg. a macro). If the tables already exist in Database 2, is it also possible to overwrite these with the new tables as they will have the same names.

    Cheers,

    Jocelyn

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Exporting Tables (Access 2000 - 2003)

    How are the tables to be exported specified?
    - They are distinguished from other tables by a special prefix (for example) in their names
    or
    - There is a separate table that lists the names of the tables
    or
    - They will be listed individually within the export code

Posting Permissions

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