If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is this too many records
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 |
Thread Tools | |
Display Modes | |
|
|