<div>
If your destination table isn't structured the same, you need to define your columns:<br />
<br />
INSERT INTO tblPeople(Col1, Col2, Col3) SELECT txtLastName, txtFirstName, txtDOB FROM tblImport
</div>


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

<div>
<div class="content wysiwyg-content">
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?<br />
<br />
tblImport has these fields:<br />
txtLastName (text)<br />
txtFirstname (text)<br />
txtDOB (Date/Time)<br />
<br />
tblPeople has the same fields plus more
</div>
</div>


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

Copy Data from One Table to the Next

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.