Cleaning up Excel Sheet before importing to Access
Posted on 2011-02-14
I have an excel sheet that has junk at the top because it's exported from a formatted Crystal Report with titles. Is there something I can do to strip off the headers before importing it into Access?
When I import to Access, the headers are not consistant and it fouls up the queries.