Index is a reserved word. You should never use a reserved word for the name of a table or column, or anything else for that matter. I mean... you can, but you shouldn't. When you use a reserved word for a column (or table) you need to put square brackets around the column name, like this:
[Index]
Since you don't have any code, I'm not sure if this suggestion will help. One thing you could try doing is to create a computed column in your SQL table. Computed columns are not "real" columns, but are actually a formula. For example, if you had a Height column and another Width column, you could create a computed column for Area, like this:
Alter Table TableName Add Area As Height * Weight
Similarly, you could create a computed column in your table that simply returns your column data, like this:
Alter Table YourTableName Add MyDescription As Description
Then, you could pull this column in to Excel and you will have the same data that was in the Index column.
Your best approach here would be to simply rename the column if you can. Otherwise try the column alias trick.
-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
