Results 1 to 2 of 2
  1. 05-15-2011, 05:11 AM #1
    forestgump
    forestgump is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2011
    Posts
    8

    Copy Table

    Hi All,



    I want to write some VBA so that I can copy the contents of one table to another table and then import new data.

    I want do this so I can run a comparison report from the current week from the previous week.

    Kind regards,

    James Elwell
    Reply With Quote Reply With Quote
  2. 05-16-2011, 07:41 AM #2
    jzwp11
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Similar data should be kept in 1 table. You can use a couple queries to separate the data. Assuming that your records have a date field you can use that to separate the data.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Copy record from one table to another
    By jpkeller55 in forum Access
    Replies: 8
    Last Post: 03-05-2013, 12:16 AM
  2. Copy Table Structure (only) Problem
    By homerj56 in forum Access
    Replies: 1
    Last Post: 07-16-2010, 10:36 AM
  3. Copy one table to another database
    By ashthebear in forum Access
    Replies: 2
    Last Post: 06-15-2010, 08:46 AM
  4. Copy record to different table
    By Patience in forum Access
    Replies: 27
    Last Post: 06-03-2010, 12:19 PM
  5. how to copy random records from a table to another table
    By venu in forum Access
    Replies: 2
    Last Post: 04-02-2010, 07:42 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums