I have a CSV file with 4 columns 100,000 rows (100,000 records). I wan
to import a portion of the data into an excel spreadsheet. And I wan
to do this on a regular basis. Currently the data is going to stay i
the CSV file (i.e. it will not be in Access unless it has to be).

Effectively I want to query the data based on the date field in one o
the columns. Is it possible to query data in a CSV file (i.e. tex
file) from VBA into Excel? I want to be able to enter a date in my VB
code and use this date to query the data to retrieve all the record
from that date.

Please and thank-yo

--
Message posted from http://www.ExcelForum.com