newbie trying to query multible spreadsheets into one table in Access 2003

[dsbsnag]

I am using Access 2003 on Windows XP

I'm a school teacher and need help achieving the following:

I have three spreadsheets with various information in them. But, they have a common cell named "Student ID".

To be specific this is what my three spreadsheets consist of is this:

Spreadsheet 1
Student ID
Last Name
First Name
Teacher
Grade

Spreadsheet 2
Student ID
FCAT Username
FCAT Password

Spreadsheet 3
Student ID
Pearson Username
Pearson Password



THis is what I have done -- and perhaps someone can let me know where I went wrong or a better way to do it.

I created a blank table in Microsoft Access named "Student Password". That table had all of the above cell names as fields.


I then imported the files (using file/import/external data) and created relationships with the tables so that they all related to the Student ID.

So far so good I think.

NExt I created a query using design view and selected the first table above and the newly created blank table.

When I run the query nothing happens. my blank table stays blank.



I then created queries using the "Student ID" as the relation.

[NeoPa]

Maybe an easier solution would be to link to the three spreadsheets which enables you to use them like (basic) Access tables.
Next create an APPEND query based on a linked query of all three tables

INSERT INTO [Student Password]
([Student ID],[Last Name],[First Name],[Teacher],[Grade],
 [FCAT Username],[FCAT Password],
 [Pearson Username],[Pearson Password])
SELECT S1.[Student ID],
       S1.[Last Name],
       S1.[First Name],
       S1.[Teacher],
       S1.[Grade],
       S2.[FCAT Username],
       S2.[FCAT Password],
       S3.[Pearson Username],
       S3.[Pearson Password]
FROM ([Spreadsheet 1] AS S1
  INNER JOIN [Spreadsheet 2] AS S2
    ON S1.[Student ID]=S2.[Student ID])
  INNER JOIN [Spreadsheet 3] AS S3
    ON S1.[Student ID]=S3.[Student ID]

Your names may be different but I've assumed exactly as you've posted.