import data within a database?

S

Steve H

I have a database with lots of tables, I want to consolidate all those tables
into one table in the same database, how can i import table to table within
the same database?
 
K

Kevin3NF

Use append queries...these are built into the query designer (not in a
wizard though) and fairly simple to create. Help has some good information

Are these tables all identical, or are you turning Access into a
spreadsheet? Most databases have a pretty large number of tables...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions
 
Top