How to select some not all column from a table then apend to another table?

  • Thread starter Thread starter Min
  • Start date Start date
M

Min

I have seen this function of Access run in Windows XP, but cannot find the
same or similar function of Access run in Windows 2000. Anyone can help?
Thanks!
Min
 
Create a query that has only the fields you want, and turn that into an
Append query (it's an option on the Query menu when you're in design mode)
 
Thanks for your reply!

Douglas J. Steele said:
Create a query that has only the fields you want, and turn that into an
Append query (it's an option on the Query menu when you're in design mode)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append two tables 3
How to Populate Data from a table to another 0
How to export table from outlook into ms access table? 0
Replacing a Table with a Table from another database - reference issues 1
How do I merge records from 2 tables into one ? 10
Turning a 3 column flat file into a "3D" Table 2
apending data to table from unbound form when form field blank 2
Access 2000 Pivot Tables 1

Back
Top