Thread: [Solved] Access or Excel?
View Single Post
 
Old 04-10-2011, 06:11 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,359
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote