Bill,
Consider importing into a temporary table where you can use the records to update or append to multiple tables.
Duane Hookom
MS Access MVP
--- In MS_Access_Professionals@yahoogroups.com, "agent1of6" <Bill.Singer@...> wrote:
>
> 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