Union query help

[lwarren1968]

I have over 200 excel files with like data that I need to combined. In the past with a few files I've added them as a linked file or imported the files and then created a Union Qry to combined, but 200 is a lot to link. Is there an easier way to run a union Qry without actually linking or importing one at a time?

 

[pbaldy]

If the files are all in the same folder, you can programmatically loop the folder and either link to or import them.

http://allenbrowne.com/ser-59.html

 

[lwarren1968]

That worked perfect! Thank you.

 

[pbaldy]

Happy to help!