Multi Exporting

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Alan Mars
    #1

    Multi Exporting

    I have Many Tables, Forms, Queries, etc that I need to export to another Access
    Database (Approx. 200). Is there a way to do that without doing it to each
    indivisual Table, Form, Query, etc?

    Tags: None
    • Rick Brandt
      #2
      Re: Multi Exporting

      "Alan Mars" <noone@home.com > wrote in message
      news:KwNcb.6959 $ev2.3554500@ne wssrv26.news.pr odigy.com...[color=blue]
      > I have Many Tables, Forms, Queries, etc that I need to export to another[/color]
      Access[color=blue]
      > Database (Approx. 200). Is there a way to do that without doing it to each
      > indivisual Table, Form, Query, etc?[/color]

      Don't push, pull.

      If you import from the destination file you can import all of the objects at
      once.


        Comment

        • hal boyles
          #3
          Re: Multi Exporting

          From the new MDB, IMPORT all of the desired objects from the old MDB.

          File, Get External Data, Import, Select the Source MDB, then select the
          specific tables, forms, queries, etc that you want to be copied into the new
          MDB.


            Comment

            • Alan Mars
              #4
              Re: Multi Exporting

              Thanks for the info. I don't know why I didn't think of that!



              In article <bl272u$r5r$1@i nntp-m1.news.aol.com >, hal_boyles@time inc.com says...[color=blue]
              >
              >From the new MDB, IMPORT all of the desired objects from the old MDB.
              >
              >File, Get External Data, Import, Select the Source MDB, then select the
              >specific tables, forms, queries, etc that you want to be copied into the new
              >MDB.
              >
              >[/color]

                Comment

                Previous template Next
                Working...