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

I am not sure what you are trying to do here. Are all the tables the same (same column names, count and data type) or are you creating one large flat table?

I would create your final table first, then do a series of append queries to move the data in. If you have any relationshisp to maintain, then you may need to use code to do this.

More info? Can you post starting table columns and ending table columns, etc.?


mmcdonal

Look it up at: http://wrox.books24x7.com