Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel Linking - how to keep the column headings if they aren't on the first row?

Posted on 2014-01-29
2
Medium Priority
?
386 Views
Last Modified: 2014-01-29
Hello - I've got a situation where I've got to get the rows from some HUGE Excel 2010 spreadsheets (200K+ rows) into Access tables, so I'm trying to link to them, rather than import.

Most of these workbooks have multiple worksheets, with report headings and dates in the first several rows. Right now, I'm specifying a range that is just the tab name.

When I link with "First row contains field names" = False, field names come across as "F1", "F2", etc...

Is there a  slick trick for applying the values in, say, the 6th row as field names?

Thanks
0
Comment
Question by:mlagrange
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 48

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 39817457
I generally use code to open the spreadsheet, delete the first 5 rows, then save the spreadsheet with a different name (so you don't destroy the original).

Then I Link to the new spreadsheet and the Column headers show up the way I want.
0
 

Author Closing Comment

by:mlagrange
ID: 39818602
That's a great idea - Thanks
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question