Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • Last Modified:

How to import from one table to another

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

http://aycu12.webshots.com/image/22811/2003164841559228389_rs.jpg
0
Takamine334
Asked:
Takamine334
1 Solution
 
FlysterCommented:
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];

Flyster
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now