Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    102

    Unanswered: Copying a Table in Access VBA

    Hi,
    I want to have a macro run in VBA
    where I copy a MS Access table and rename it.

    Essentially, the code goes as follows:

    ****************************

    1. Do data manipulation
    2. Delete table "Table1"
    3. Copy table.
    4. Rename table to "Table1"


    **************

    This code runs in a loop.

    I could do it by using "Select/INTO" statements.
    But I assume there's a faster and more effective method.


    Also, the data manipulations are based on a query which is based on the
    renamed table "Table1". Will the integrity hold up for each loop of the code.

  2. #2
    Join Date
    Dec 2003
    Location
    Östersund Sweden
    Posts
    60
    Hi,

    I´m not clear with Your situation.

    Do You want a VBA-solution in Excel to do the job?

    Yes, it is possible except for deleting a table.

    Please let us know more about it.

    Kind regards,
    Dennis
    Kind regards,
    Dennis

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    Look at the help for the docmd object - there is a method called runmacro.

Posting Permissions

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