Excel Linking - how to keep the column headings if they aren't on the first row?
Posted on 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?