How to copy one table contects into a different table in MS Access 2007?

Posted on 2011-04-26
Last Modified: 2012-05-11
How to copy one table contects into a different table in MS Access 2007?
Question by:Troush2009
    LVL 12

    Expert Comment


    Expert Comment

    Does the table you are copying to already exist, or are you going to be creating a new table? Are the two tables in the same database?
    LVL 12

    Expert Comment


    Or write a query to insert the table, likely the first two options will be what you wanted.

    Let me know if there is anything further.
    LVL 119

    Accepted Solution

    assuming your table name is A and you want to copy all contents to table B in the same database

    using a query

    insert into B
    select A.*
    from A

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now