Missing Data Query Problem

[Jingmei]

Hello, I have been getting missing data when trying to join information from two workbooks in Excel.

The first worksheet, Grades, has data about each course each student took in a semester organized by student ID. Student IDs are repeated for each course a student took.

The second workbook, Visits, has demographic data about students, and visit dates to a certain location. Student IDs are duplicated for each visit during that semester.

I want to find the ids in Grades that match the ids in Visits and add the grade data to the Visits worksheet, without losing any of the grades or visit data. W



hat is the best way to run a query in Access to do this? I used the query wizard to do this, but I had too many missing ids from the visits list. There would not be that large of a number students with no courses for a semester.

I should say that the actual grades worksheet is about 117,000 rows long while the visits table has about 1939 rows. So, the not all of students in the Grades worksheet are present on the Visits worksheet.

I am really stuck with this.
.

[ranman256]

Yes access is the way. Import all your data into access, then query everything.
Relate all tables, and run it all in access.