Append multiple queries into an empty table via code

  • Thread starter Thread starter Durango
  • Start date Start date
D

Durango

I am fairly new to access and have been struggling on how to do the
follow and would appreciate any help.

I have multiple queries called
"Qry_Route01","Qry_Route02","Qry_Route03", and so on. Each query has
two fields [cabletag] (Same in all Queries) and [Route01] or [Route02]
or [Route03] and so on. The [route01] is in query "Qry_Route01" and
[route02] is in query "Qry_Route02" and so on.

I have a empty table called "Tbl_Temp_Route" which contains the fields
[Cabletag] and [Route]. What I would like to do via programming code is
to have all the [Cabletag] and [Routes] appended to the table. I don't
know if I should do it via SQL or what the best and easiest solution
is. I am still trying to understand how to program via SQl, but it
doesn't look like the help with the ACCESS is that great.

Can any one help?
 
Back
Top