Can I run an append query on a group of files?

[George Chen]

Is it possible for me to group all my data files together in a subfolder like
structure such that I can run an append query on the subfolder and have all
the data files combined into one giant table?

How would I define the subfolder and program the query?

 

[Lord Kelvan]

i take it you are basing this on your last post yes you can i would
never use that termanology but i think i understand what you mean

THIS IS WHAT YOU DO

select *,"thisistable1data" as table1idfield
from table1
union all
select *,"thisistable2data" as table2idfield
from table2
union all
select *,"thisistable3data" as table3idfield
from table3
union all
etc ...

i hope this makes sence

Regards
Kelvan