Elad,
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?
Kevin
dartcoach