When I run a macro that imports an Excel spreadsheet into an existing Access Table, it appends the data fine. The only problem is, the first couple of records are out of order. I tested it by putting a different date on each row in the spreadsheet. When I imported it into Access, the first couple of dates were out of order.

Any ideas would be very appreciated!!