Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2009
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am trying to copy a couple of tables from one database into a new, similar database. The table I am trying to copy has subforms; is it possible to copy these subforms as well somehow?

    What I have been doing is copying and pasting the tables into Excel and then copying and pasting the data into the new Access databse. Unfortunately, this method does not account for the subformdatasheets contained in each entry of the original table. There are quite a few entries in this table, and I really don't want to take the time to type each one in individually.

    I am a very, very novice Access user, fwiw.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can import tables directly from one Access database into another one. This should preserve their structure.

    In Access 97, 2000, 2002 or 2003:
    - Open the database into which you want to import the tables.
    - Select File | Get External Data | Import...
    - Navigate to the other database and click Import.
    - Select the tables you want (you can select more than one).
    - Click OK.

    In Access 2007:
    - Open the database into which you want to import the tables.
    - Activate the External Data tab of the ribbon.
    - Click on Access in the Import section.
    - Click Browse...
    - Navigate to the other database and click Open.
    - Click OK.
    - Select the tables you want (you can select more than one).
    - Click OK.
    - Click Close.

  3. #3
    New Lounger
    Join Date
    May 2009
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yeah, I figured that out shortly after posting this. Unfortunately, the system was telling me I didn't have authorization to perform such an action, but I was able to get the tables right by establishing the proper relationships. It was a little more time-consuming than I wanted it to be, but considering this is the first database I have ever assembled, I can use the practice with the relationships function, so no big deal.

    Thanks for your help, Hans! I highly doubt this will be the last question I post here this semester...

Posting Permissions

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