Hi Martin,
Martin said:
Many thanks to everyone for giving up their time to help.
I realised whilst in bed(!) that I had been ambiguous with my request. My
problem is adding extra data to records that already exist in tables. It's a
database that I have written for my school. I often receive data for pupils
on floppy disk that I need to add to their existing records. I frequently
end up copying and pasting this data one pupil at a time, but would very
much like to know if a facility exists to import the data to the correct
pupil automatically.
Neither Access nor Excel "know" which data go with which pupil, nor
which pieces of information go in which tables, unless you tell them how
the information is related. Migrating data from other formats into a db
always involves some effort on the data manager's part, even if it's
just following the prompts from the Import Spreadsheet Wizard. Are you
adding new pupils & their records, updating existing students' records,
or both? In either case, you'll need to bring the data into your
database using File | Get External Data | Import (linking to a file on a
floppy is too problematic). If you're trying to APPEND new data to your
tables, just follow the Wizard's instructions for adding new data to
existing tables. If you're wanting to UPDATE existing records in your
tables, that's a whole 'nother ball game. Import the spreadsheet as a
new, temp table and create an Update query joining the temp table to the
table containing the information that needs to be updated. See the OLH
for help on how to create an Update query.
hth,
LeAnne