contact database

[Guest]

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.

 

[dbahooker]

you should just have one table, princess

 

[John W. Vinson]

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.

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]

 

[dbahooker]

CORRECTION

Access _IS_ Excel on Steroids
and SQL Server _IS_ Access on Steroids