comparing Excel & Access spreadsheets

[Agtuary]

I essentially have two spreadsheets with similar information, in slightly different formats. In Excel data is stored in tabular format with row & column labels (SSN for rows, years for columns). The similar information in Access has a seperate row for each SSN & year. I want to know what the differences are between the two. Any suggestions on an easy way to do this? I don't know enough to write any VB in Access and very little in Excel.

[Obi-Wan Kenobi]

Create a pivot table in Excel based on the Access table.

[Cho Da]

write a crosstab query in access
TRANSFORM sum(dollars) AS Dollars
SELECT SSN
FROM yourTable
GROUP BY SSN
PIVOT YEAR;