combine tables

[reza_doang]

hi all,

background:
i have 10 excel files which every file have almost 1.000.000 rows.
using access i want to combine all file become database.

what i do:
using access, i import one by one all excel file into access. so in 1 file access i have 10 table without primary key.

what i want to:
how to combine all table become one table?

many thanks for your help.

reza

 

[Trevor G]

You will need to use append queries to do this, and perhaps one make table.

you can then run all the appends from a macro so you get the database to run eveything in one go, and set the warnings to off once you have tested it so you don't keep seeing messages like you are about to run an append query followed by you are about to append XXXXXXXXXXXXXX records etc.

 

[alansidman]

An alternative to Trevor's suggestion (which will work) is to create a union query to combine all the tables. Then create a make table query to get everything into one table.

Alan

 

[reza_doang]

thanks for your response,
but can you teach me how to achieve that?
many thanks for your guidance

reza

 

[alansidman]

Here is a tutorial on Union Queries

http://www.bluemoosetech.com/micros...Microsoft Access SQL: Union Queries (Part 1)

and then

http://www.bluemoosetech.com/micros...Microsoft Access SQL: Union Queries (Part 2)

Here is an instructions on Make Table Query

http://www.databasedev.co.uk/make-table-query.html

Lastly if you decide to do a Append Query first then look at this.

http://www.databasedev.co.uk/append_query.html

Post back with any issues you have once you have begun the process.

Alan

 

[reza_doang]

alansidman

thanks for the links.
its really great...i think i can handle this now.

thank you