Anthony, If you have SAS/Access for PCfiles, I would go about solving the problem as follows (you can copy, paste and run the code from this point on): *First, I would identify the spreadsheet in a libname. I used the getnames=no option to ensure that the first line is read as data rather than field names, and mixed=yes to ensure that all data is read as text; libname students "c:\students