Re: Excel and large numbers of linked files

[Peter <pnewman1 -at- home -dot- com>]

"Ehr, Meg" wrote:
> 
> Thanks to all who offered input and assistance on my questions. Seems the
> boss discovered an existing Access DB with some of the info we need, so now
> I'll be doing my project in Access instead of Excel. At least now I have
> some semblance of structure to start with!
> 
> Now, of course, I have two days in which to re-learn Access (hardly touched
> it in four years) and get this thing set up...

Spend the bulk of time with your pen and paper. Design the relationships
of the tables so that each row in each table has a unique identifier.
SQL for Dummies, is an excellent concise summary of database design.

-- 
Peter
Mailto:peternew -at- optonline -dot- net

Adapting old programs to fit new machines
usually means adapting new machines to
behave like old ones.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Be a published author!  iUniverse gives you: a high-quality paperback, a
custom cover design, and distribution to 25,000 retailers.  And it's
affordable.  Join our almost 10,000 published authors today.
http://www.iuniverse.com/media/techwr

Sponsored by eHelp Corporation, makers of RoboHelp - the industry standard
in Help authoring. Download a trial version today or get special savings when 
you buy the RoboHelp 2002 Holiday Edition. Visit http://www.ehelp.com/techwr

---
You are currently subscribed to techwr-l as: archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot-  Visit 
http://www.raycomm.com/techwhirl/ for more resources and info.