map table wizard??

[Gaufres]

Hi

I want to manipulate a few tables and make them into one table, but I don't want all of their fields. I heard that I could do it with "map table wizard" from the top of the menu. Where can I find it? Or, can anyone recommend me what I should do better?

I use Office 2002.

Thanx.
Gaufres

 

[Pat Hartman]

Create a query that joins the two tables.
Select the columns you want from each table.
Change the query type to "make table" (not map table).
Assign a table name.
Run the query.

 

[Gaufres]

Thank you!

Thank you, Pat Hartman! I made it!