How can I combine multiple tables in Access

**L_ter** · 03-12-2009, 02:00 AM

Hi,

What i want to do is to combine multiple tables in access how can i d this ???

Any Suggestions

Thanks

**mudraker** · 03-12-2009, 06:45 AM

Create an append Query

There are many example on the net on how to create these queries

Here are a couple of sites

http://www.ehow.com/how_14047_create-append-action.html
http://office.microsoft.com/en-us/ac...860631033.aspx
http://www.databasedev.co.uk/append_query.html

**L_ter** · 03-12-2009, 11:26 PM

Thanks mudraker for this help.............

J.wills · 03-12-2009, 11:56 PM

You can create a new blank table and Append each table into the single new table by this you can combine multiple tables.

**L_ter** · 03-12-2009, 11:58 PM

so would i have to load all the files over again?

I was hopping i could just merge all the tables into one since they are already loaded into Access.
when you say APPEND, i would have to RE-LOAD the files - is that right??

J.wills · 03-13-2009, 12:00 AM

No, you do not have to relaod them. You can copy one of the table as structure only. Then create an append query to write the data from the existing quarterly table to the new Year table.
Do you know how to create an append query?