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

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
mlagrangeAsked:
Who is Participating?
 
Dale FyeConnect With a Mentor Commented:
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
 
mlagrangeAuthor Commented:
That's a great idea - Thanks
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.