On Jul 6, 11:54*pm, Dave wrote:
Am I able to do this within a single query?

No, you'll need to run an append query against each text file.

I wonder if you couldn't create an import specification and then use
TransferText. If all the text files are in a single directory, you
could just use DIr to loop oover the contents of the directory and
process with TransferText and your import spec. (sorry about the
typos, I'm not watching what I'm typing...)

If you dig around here or in the help there is an example of how to
use Dir to loop over the contents of a directory... better yet...
check out allen browne's website...

www.allenbrowne.com
He has an example of a recursive search, among other things.