Hello,

Thanks for your reply...

I am wondering if what your suggesting is the best route to take since i am
stuck at the moment - i think its worth a try but it does pose another
problem...

How would i ensure data-integrity when exporting columns of data from Excel
into Access in 2 different tables...?

Have you got any tips in this scenario...?

Many thanks,

Alex



"keepitcool" wrote in message
...
I'd say.. split your database in 2 tables:

1 custID, custName etc
2 custID, noteDate, NoteDesc etc

retrieve the cust then lookup their notes.

i realize that any redesign is a chore..
but with 20.000 records I assume /presume :)
it's outgrown the original idea..



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


": VB :" wrote:


I have realised that within the spreadsheet of 20,000 records, there
are repeat rows - basically, the spreadsheet lists customer
information and also, notes. Rows of customers can be identical
except for the notes field which is always different.