ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I not overwrite my column headers when I do an ODBC refres (https://www.excelbanter.com/excel-discussion-misc-queries/226322-how-can-i-not-overwrite-my-column-headers-when-i-do-odbc-refres.html)

Glen

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.

Luke M

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.


Glen

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.



All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com