Extract 8 Tables into 1 Large Table

[hewstone999]

I currently have 8 tables in my Database.

How can i extract all the information in those tables and put all the data into one large table? I want to extract everything apart from one table?

and can I format the large table once the data have been put in i.e. insert new Columns at the start, and populate fields based on the value of other fields values?

Any ideas or help? thanks

Kind Regards
Richard

 

[tehNellie]

You'll need to be a bit more explicit about what you're trying to achieve here. can you not just use a query to present the information in the way you want?

 

[hewstone999]

yeah sorry, im new to VBA and SQL and dont no much about the code side of things. Basically i want all the information in my 8 tables, to be put into 1 table - So i will end up with one table instead of 8.

 

[Ron_dK]

I currently have 8 tables in my Database.

How can i extract all the information in those tables and put all the data into one large table? I want to extract everything apart from one table?

Richard,
The way to go here is to set up queries. Assuming your database is normalized, you should not go in the direction of flattening your Dbase, i.e. put all data/records from 8 tables into one table.

If you're not sure, search for normalis(z)ation.

Hth

 

[Rabbie]

I currently have 8 tables in my Database.

How can i extract all the information in those tables and put all the data into one large table? I want to extract everything apart from one table?

and can I format the large table once the data have been put in i.e. insert new Columns at the start, and populate fields based on the value of other fields values?

Any ideas or help? thanks

Kind Regards
Richard

You can use UNION queries to collect data from different tables into one recordset which you can use to populate you new table. See access help for more info.