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.

Thanks,
Craig
OnsiteSupportAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
in codes > not manually..
0
 
jppintoCommented:
You can simple delete those lines, no?
0
 
Rey Obrero (Capricorn1)Commented:
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.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
jppintoCommented:
...those ROWS, no?
0
 
OnsiteSupportAuthor Commented:
0
 
OnsiteSupportAuthor Commented:
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.

Thanks
0
 
Rey Obrero (Capricorn1)Commented:
you can create a copy of the excel file (in codes)
delete the last row in codes
how is the first row be cleaned?
0
 
OnsiteSupportAuthor Commented:
Sorry  What do you mean by "In Codes?"
0
 
OnsiteSupportAuthor Commented:
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
0
 
mlmccCommented:
You could export just the data then you should get the fieldnames as the titles

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

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.