Solved

Copy Data from One Table to the Next

Posted on 2011-03-25
2
210 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

762 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

23 Experts available now in Live!

Get 1:1 Help Now