Solved

Copy Data from One Table to the Next

Posted on 2011-03-25
2
212 Views
Last Modified: 2013-11-05
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
Comment
Question by:gcgcit
2 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 35215279
you can use an append query

insert into tblPeople
select tblImport.*
from tblImport
0
 
LVL 84
ID: 35215489
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

914 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

19 Experts available now in Live!

Get 1:1 Help Now