combine tables into one

  • Thread starter Thread starter joseph patterson
  • Start date Start date
J

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
 
joseph said:
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
Click to expand...

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".
 
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 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.
 
Back
Top