Access Query - Union of TEXT files that are selected.

A

Angela

Hi,

I was wondering if this can be done.


I will place the link name of delimited text file in a table1 in
filed
name like "c:\abc\test1.txt", "c:\abc\test2.txt", "c:\abc\test3.txt"
and so on.
The delimiting character is "|".
The next column is Select yes/no in which I have option to tick the
file that I want to select.


Now I want a query to include the file/files that I select in table1.
It can be single file or multiple file.


Since the text files change frequently, I wish not to import them or
link them.
Instead I want to have a selection query of my choice.


I hope I have explained it neatly.


Looking forward for a solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top