You can read your text file in Access, load it to a table, run your query and export it back to excel. All with VB
1. Is the text file always in the same format?
2. Are the fields in the text file fixed with, or delimited?
3. What are you changing in excel before you import the excel file to access?