is it possible to keep data in a text file and use vb to only import the
data from a tet file that meets a certain range of criterias. this would
be very helpful where there are more then 64,000 entries


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=482249

That is possible but from your description you might be better off with a
database. That being said here is a link to a site which might help. You need
to create an ADO recordset...

http://www.erlandsendata.no/english/...php?t=envbadac
--
HTH...

Jim Thomlinson


"ceemo" wrote:


is it possible to keep data in a text file and use vb to only import the
data from a tet file that meets a certain range of criterias. this would
be very helpful where there are more then 64,000 entries


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=482249