Quote:
Originally Posted by Pirate Bill
I've never tried deduping in Excel, but I do it all the time in Access (just one of my usual tasks here at work). So I'm wondering, why use a spreadsheet for database type work?
|
Because I have Excel and I know how to use it. There is only one project that I need to do this one, so I haven't taken the time to get and learn Access (or Fox Pro). The main thing I use Excel for (often in conjunction with Word) is for cleaning up sloppy data entry and for re-formatting before importing into Filemaker Pro, which is where we do the actual publishing.
There may be better ways to accomplish this, but I am using the tools I know. If this we're a full time project, I would either learn new tools or (more likely) hire a programmer.