How to import from one table to another

Posted on 2007-07-29
Last Modified: 2007-12-19
How would you import records from one table to another on the same database (MDB) using VB6 code? I'm trying to go from all_users to musicians_Default.

I've attached a screen shot
Question by:Takamine334
    1 Comment
    LVL 22

    Accepted Solution

    You can use this append query:

    INSERT INTO musician_Default_Table ( ID, Name, Age, Sex, City, State, Country, Birthday, Picture, Music, [Last Login] )
    SELECT [all_users-Table].ID, [all_users-Table].Name, [all_users-Table].Age, [all_users-Table].Sex, [all_users-Table].City, [all_users-Table].State, [all_users-Table].Country, [all_users-Table].Birthday, [all_users-Table].Picture, [all_users-Table].Music, [all_users-Table].[Last Login]
    FROM [all_users-Table];


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
    Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    779 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

    13 Experts available now in Live!

    Get 1:1 Help Now