Hi Adam,

My first observation is that your worksheets have a lot of duplicated, hence redundant data. Provided each client has a unique ID, that is the only datum required on all sheets. Aside from anything else, this reduces the risk of inconsistencies between the two sets of data. In this regard, you'd probably do best to have one sheet with the details of each client, then whatever other sheets you need for, say, referring agency details and for tracking clients' history. As it is, though, if you're going to have a separate record for each 'event', you could probably have the whole lot on one worksheet.

Whichever way you go, I don't think there'll be a significant issue exporting the data to Access - provided you eliminate the data duplication. Access can import Excel workbooks and various other files formats, including CSV to which Excel can output data.

As for reading the file, I have both Office 2000 and 2007 installed. In any event, Office 2000 can read Office 2007 files courtesy of a format converter from MS.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]