• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

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
0
OnsiteSupport
Asked:
OnsiteSupport
  • 5
  • 3
  • 2
  • +1
1 Solution
 
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
 
jppintoCommented:
...those ROWS, no?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
 
Rey Obrero (Capricorn1)Commented:
in codes > not manually..
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.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 5
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now