Why don't you use a database to store your database?

MH

"Edmund" wrote in message
...
Via VBA code, is it possible to jump straight to a specific row number
within
a ".txt" file?

My database is 250MB in size. There are 4 million rows in it. Presently,
my
macro cycles through from top to bottom, then repeat cycle until every
listed
part number is found. This is pain staking.

Pls show me the codes, if any.

--
Edmund
(Using Excel 2000)