• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

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