Link to home
Start Free TrialLog in
Avatar of OnsiteSupport

asked on

Cleaning up Excel Sheet before importing to Access

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.

Avatar of jppinto
Flag of Portugal image

You can simple delete those lines, no?
Avatar of Rey Obrero (Capricorn1)
have you tried importing the excel file into a temp table without the column names?

btw, better if you upload a copy of the excel file and give details what you want to be cleaned.
...those ROWS, no?
Avatar of OnsiteSupport


ippinto....I want this automated as part of an application for anyone to import the data.  I don't want them touching the "raw" spreadsheet.

you can create a copy of the excel file (in codes)
delete the last row in codes
how is the first row be cleaned?
Sorry  What do you mean by "In Codes?"
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It was just a bit painful matching column names to real names in the query.  Guess I can't get around that one.

Thanks for the tip
You could export just the data then you should get the fieldnames as the titles

The design of the headings in crystal causes the export to jumble the order of columns.
If you choose the data only then the report headings don't get used but the field column names.