ExcelBanter - Excel Windows Authentication to SQL Server

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

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

- - Excel Windows Authentication to SQL Server (https://www.excelbanter.com/excel-discussion-misc-queries/217063-excel-windows-authentication-sql-server.html)

John Couch

Excel Windows Authentication to SQL Server

Is there a way to have Excel AUthenticate to SQL Server via UDL file similar
to using a ODBC DSN?

joel

Excel Windows Authentication to SQL Server

I'm not an expert in SQL but I was reading a book last night. ODBC is the
older verions of data accesses and doesn't support SQL. You need to move up
to ADO which will support SQL. ODBC was used prior to Excel 2000. ADO was
1st introduced in Excel 2000 with enhancements added in Excel 2003.

"John Couch" wrote:

Is there a way to have Excel AUthenticate to SQL Server via UDL file similar
to using a ODBC DSN?

All times are GMT +1. The time now is 06:56 AM.