combine tables into one

[joseph patterson]

dear experts,

everyday i have to combine tens of similarly structured tables into
one. i done the copy and pastings for some time and i'm very sure that
this is not the efficient thing to do.

pls suggest me an efficient method to accomplish this task.

i thank u all very much.



joseph

 

[Douglas J. Steele]

Try using an Append query.

 

[Randy Harris]

done that.

i still have to open each and everyone of them everyday to perform the
append query.

i believe there is a minimal steps (maybe 3-4 steps) to accomplish
this.

your reply is appreciated.


joseph

You're not being very clear. You first suggested that you were using
copy/paste. Doug suggested you use an append query, you replied that you
had already done that. If you save the append query, you can simply run it
every day. There would be no need to "open each and everyone of them
everyday". Perhaps you should describe just what it is you are doing
"everyday".

 

[joseph]

done that.

i still have to open each and everyone of them everyday to perform the
append query.

i believe there is a minimal steps (maybe 3-4 steps) to accomplish
this.

your reply is appreciated.


joseph

 

[eleland]

You shouldn't need to open your tables daily to run your append query!! Perhaps the best thing to do is to create a macro to run the append query each tme you close your database.