Union query help (1 Viewer)

lwarren1968

Registered User.

Local time

Today, 06:23

Joined

Jan 18, 2013

Messages

77

• Dec 10, 2018

• #1

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

Wino Moderator

Staff member

Local time

Today, 06:23

Joined

Aug 30, 2003

Messages

36,124

• Dec 10, 2018

• #2

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

Registered User.

Local time

Today, 06:23

Joined

Jan 18, 2013

Messages

77

• Dec 11, 2018

• #3

That worked perfect! Thank you.

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 06:23

Joined

Aug 30, 2003

Messages

36,124

• Dec 11, 2018

• #4

Happy to help!