External Query questions
Hey Bryan
If your getting data but no column names, it sounds like you need to edit
your External Data Range Properties. To do that simply right click on the
upper most left cell on your new data sheet. Choose' data range properties'
and check off 'include field names'
that should do it for ya!
Gary
"Bryan Dickerson" wrote:
Using Excel 2003, I'm trying to populate a spreadsheet with a simple ODBC
query that has some user-friendly column names in the query, but
unfortunately, they won't show up in the spreadsheet. I've done
spreadsheets populated by Stored Procs before with no problems on the column
names, but this seems a bit odd. Is it more likely an ODBC or an Excel
problem??
Thanx!
|