 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007contact database
i have about 10 excel spread sheets some with 1000 contacts others up to 200. If i want to create a generic database for them in acess would i put them all into one table or should each spreadsheet have it's own table. Also they all have the same fields in them except for which spreadsheet they came from so im confused about the Primary keys and relationships. Thank you in advance Sorry I am a 2week newbie to access and all the manuals are not helpful to me. you should just have one table, princess On May 17, 8:10 am, Kimberly <Kimbe...@discussions.microsoft.com> wrote: > i have about 10 excel spread sheets some with 1000 contacts others up to 200. > If i want to create a generic database for them in acess would i put them [quoted text clipped - 4 lines] > Thank you in advance > Sorry I am a 2week newbie to access and all the manuals are not helpful to me. >i have about 10 excel spread sheets some with 1000 contacts others up to 200. >If i want to create a generic database for them in acess would i put them [quoted text clipped - 4 lines] >Thank you in advance >Sorry I am a 2week newbie to access and all the manuals are not helpful to me. I would certainly recommend *one* table, perhaps with another field to distinguish what are now separate spreadsheets. Note that Access is emphatically NOT "Excel on steroids". Applying spreadsheet logic to database design is pretty sure to get you into real trouble. There are almost too many resources out there, but check out the Database Design 101 links at Jeff's site, and the other links there and on the Access Web: Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/accessjunkie/resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html John W. Vinson [MVP] CORRECTION Access _IS_ Excel on Steroids and SQL Server _IS_ Access on Steroids On May 17, 5:59 pm, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote: > On Thu, 17 May 2007 08:10:01 -0700, Kimberly > [quoted text clipped - 21 lines] > > John W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.