Jumat, 06 April 2012

[MS_AccessPros] Importing Data

 

I have imported 1 Excel spreadsheet into 1 Access table before. Now I am being asked if I can import 1 Excel table into two tables. Actually the user does not care how many tables I have, they just do not want to type the information in. (700 records, 6 fields per record.) I have two table that store the data,with a one to many relationship. Can I import through a query to seperate the data the way it should be seperated?

The first table stores a players name, address etc.
The second table stores what season the player is registering for.

Over the years one player will register for multiple seasons... which brings me to the second issue. Next Year I may be asked to import records for players that are already in the database, How do I prevent that? In that case i would just want to import the new year they will be registering for.

The data base works better if they inut each person one at a time but I understand that it is a lot of typing.

Thanks
Bill
MN

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar