I have been asked if an access database can import a csv file with
approx 2.5 millon rows (but only 2 columns)

One of the above columns is a 9 digit ref no - only numbers no
characters - we then want to create a simple search form to search
against the ref no.

So can access handle that many records and if so what is the best way
of creating / setting up a / the tables so that the search form will
still work comparitivly quickly.

Alternatively if Access is not suitable what program would you
suggest.

with thanks

Bob