• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • 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
0
gcgcit
Asked:
gcgcit
1 Solution
 
Rey Obrero (Capricorn1)Commented:
you can use an append query

insert into tblPeople
select tblImport.*
from tblImport
0
 
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
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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