10-17-2002, 02:56 PM
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.