• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

Copy Data from One Table to the Next

What is the easiest way to copy data from one table to the next when the destination table has more fields than you are importing in?

tblImport has these fields:
txtLastName (text)
txtFirstname (text)
txtDOB (Date/Time)

tblPeople has the same fields plus more
1 Solution
Rey Obrero (Capricorn1)Commented:
you can use an append query

insert into tblPeople
select tblImport.*
from tblImport
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If your destination table isn't structured the same, you need to define your columns:

INSERT INTO tblPeople(Col1, Col2, Col3) SELECT txtLastName, txtFirstName, txtDOB FROM tblImport
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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