| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I not overwrite my column headers when I do an ODBC refres
I don't want to overwrite my custom column headers when I do an ODBC refresh
but I don't know how to stop Excel from overwriting with the field names from the SQL database. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I not overwrite my column headers when I do an ODBC refres
Create 2 rows of headers. Top row is your Custom headers, row 2 is the
default values from ODBC. Have it refresh starting on 2nd row. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Glen" wrote: I don't want to overwrite my custom column headers when I do an ODBC refresh but I don't know how to stop Excel from overwriting with the field names from the SQL database. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I not overwrite my column headers when I do an ODBC re
Luke - that doesn't really solve the problem. I don't want the users to see
the "wrong" field names. I will do it if there is no other way but I'm still looking! Thanks, Glen H "Luke M" wrote: Create 2 rows of headers. Top row is your Custom headers, row 2 is the default values from ODBC. Have it refresh starting on 2nd row. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Glen" wrote: I don't want to overwrite my custom column headers when I do an ODBC refresh but I don't know how to stop Excel from overwriting with the field names from the SQL database. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ODBC Overwrite existing cells | Excel Discussion (Misc queries) | |||
| make column values column headers | Excel Discussion (Misc queries) | |||
| Pivot Table to be refreshed whenever the web query is being refres | Excel Discussion (Misc queries) | |||
| Excel - returning column headers in a seperate column | Excel Discussion (Misc queries) | |||
| How do i stop the colors changing on my pivot chart when i refres. | Excel Discussion (Misc queries) | |||
Linear Mode
