How do I combine 2 tables in access 2003?

's Computer Specifications

I have imported 2 tables from Excel into Access 2003. One is 400+ DVDs and
the other is 200+ CDs. The columns are identical, and I want to combine them
into a single table and build queries on the single table.

CLBiggs

's Computer Specifications

"cbiggs99" <(E-Mail Removed)> wrote in message
news:16BE6214-D5FA-4A3D-A57D-(E-Mail Removed)...
>I have imported 2 tables from Excel into Access 2003. One is 400+ DVDs and
> the other is 200+ CDs. The columns are identical, and I want to combine
> them
> into a single table and build queries on the single table.

Either create a new table and then run two append queries to append the
records of each imported table to the new table, or else pick one of the
existing imported tables and run an append query to copy the records from
the other imported table into it.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

's Computer Specifications

Thank you.
--
CLBiggs

"Dirk Goldgar" wrote:

> "cbiggs99" <(E-Mail Removed)> wrote in message
> news:16BE6214-D5FA-4A3D-A57D-(E-Mail Removed)...
> >I have imported 2 tables from Excel into Access 2003. One is 400+ DVDs and
> > the other is 200+ CDs. The columns are identical, and I want to combine
> > them
> > into a single table and build queries on the single table.
>
>
> Either create a new table and then run two append queries to append the
> records of each imported table to the new table, or else pick one of the
> existing imported tables and run an append query to copy the records from
> the other imported table into it.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I combine worksheets w/o enough rows to combine?	Amanda W.	Microsoft Excel Worksheet Functions	3	9th Jun 2009 07:26 AM
Combine cells with the same reference and combine quantities	brandon	Microsoft Excel Misc	2	17th Sep 2008 05:44 PM
Creating archive tables for Access tables joined to Sybase tables	=?Utf-8?B?QXJjaGl2ZSBUYWJsZXM=?=	Microsoft Access External Data	0	11th Jan 2006 11:31 PM
How do you combine several tables into one table in Access?	=?Utf-8?B?R3dlbmRvbHlu?=	Microsoft Access	6	19th Apr 2005 10:45 PM
Combine two tables in Access	=?Utf-8?B?cXVhcnR6?=	Microsoft Access Queries	2	29th Oct 2004 05:05 AM