Query & Search an external CSV using Access

[isabel2005]

Hi,

I'm wondering how I can create a query that will read a CSV file.

Here's the scenario.

User browse the directory on the computer or network drive, then select a .txt file to query.

sample txt file:
"Bob Dolan", "Dallas", "TX", "789-456-7896"
"John Smith", "New York City", "NY", "123-456-7896"
"John Smith", "Dallas", "TX", "789-456-7896"

After user import the txt file. User can perform search by entering name like John Smith and would see result of all matching name.

I also hope that it can query multiple .txt files but if I can't, then I will just select one by one.

Thanks in advance.

 

[MarkK]

I mean, if you've got to do a lot of this searching text files, why not just import all the data into Access tables? It'd seem like a headache to me to keep all this data in multiple .csv files and link them in one by one and search them and then what, unlink them again?