I have an Excel spreadsheet that I link to from Access. The spreadsheet has 8 rows of header data and the 9th row is the actual field header. Also the last row has a Total that I do now want to import either. How do I make Access recognize the header row and then import the recordsets into a table with appropriately named columns? The spreadsheet is attached.