reading column names from excel worksheets

Question

reading column names from excel worksheets

klineandking

SSCrazy

Points: 2570
More actions
August 31, 2010 at 4:38 pm

#387708

i want my excel connection to read column names from my excel worksheets in which the column names do not start in the first row

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95461 More actions · Answer 1

You can use a named range instead of the sheet (sheet has a $ at the end; named ranges don't, and can also specify the column/row for both the starting/ending of the range). However, all of the column headings do have to be in the SAME row.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2