Bill-
What is the layout of the tables where you want to import the data? How are the
tables related? Perhaps there's a way to define a "special" input form so they
can enter the relevant data all in one line like they can in Excel. You can
show them that when they're entering data for an existing player, they only need
to enter the registration info. That should get them off Excel.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-------------------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane
Sent: Saturday, April 07, 2012 5:22 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Importing Data
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