ExcelBanter - SQL OBDC Connection

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SQL OBDC Connection (https://www.excelbanter.com/excel-discussion-misc-queries/158022-sql-obdc-connection.html)

Richard

SQL OBDC Connection

OS MS XP
Excel 2002

Can someone tell me where the SQL OBDC connection information is stored?

Is there an easy way to edit the OBDC source from within Excel?

Thanks in advanced.

--
Richard

Murray

SQL OBDC Connection

You set your ODBC connections up in control panel Administrative tools.

"Richard" wrote:

OS MS XP
Excel 2002

Can someone tell me where the SQL OBDC connection information is stored?

Is there an easy way to edit the OBDC source from within Excel?

Thanks in advanced.

--
Richard

All times are GMT +1. The time now is 02:39 PM.