Appending tables

[davesmith202]

I need some code to append 3 tables together. What is the easiest way to do this? Do I create the SQL by creating an append query first? Or should I use recordsets?

Thanks,

Dave

 

[namliam]

Queries... possibly a union query...

Why merge that data? The data must be in seperate tables for some reason?

 

[davesmith202]

I can't use a union query because I understand the data is not updatable. Yes, it has to be in 3 seperate tables to start with.

 

[namliam]

Yes a union query is not updatable, but you can use a union query to insert everything into one table.

Also Union querys work wonders for reporting and stuff.

 

[davesmith202]

Ahh, I just created 3 Append Queries, ready for a sequential append. Is that the best way to do it? Or create one Union query and then use that to insert into one table?

 

[namliam]

3 seperate appends or one append with a union... doesnt make a difference, but for number of queries called.

 

[KenHigg]

I'm sort of thinking one make table query(if the original data tables are not updateable) and two append queries?

 

[davesmith202]

Ok, I have made 3 append queries where tables 1,2 and 3 are appended to table 4. What code would I need to run these in sequence?

 

[namliam]

Currentdb.execute "Query1"
etc...

 

[davesmith202]

Oh simple then! Thanks!

 

[namliam]

Sometimes solutions are just simple ..

 

[KenHigg]

Yrev elpmis

 

[davesmith202]

Got an error!

Currentdb.execute "Query1"

Is Currrentdb something I have to declair?

 

[KenHigg]

Noos oot ekops

 

[davesmith202]

Sorry? Not understanding...

 

[davesmith202]

Error was due to something else. Sorted! Thanks for your help.

 

[namliam]

Noos oot ekops

Yes "Spoke too soon" appearently, tho maybe more readable as "noos oot ekopS" or "ekopS oot noos"

LOL

Currentdb.execute is not something you have to declare, it should (always) be readily available.

If there is an error it may be relating to the Append queries...
Try running the queries one at a time by hand see if you get an error that way...