I have a spreadsheet that I'd like to import into Access 2010 however prior to the import, I'd like to delete some of the rows in the spreadsheet.
The spreadsheet only has one workbook.
It will likely always be rows 1-10.
I have already set up the Excel 14.0 Object reference, if that's even necessary
How can I accomplish this using either VB or query?
Thanks!