My brother-in-law has a question. See below, anyone?
I am trying to connect an excel spreadsheet to SQL Server 2005 using VBA and ADO. The problem is that I have to install the SQL Server client on my machine because Excel does not seem to want to talk to the db unless I use the SQLNCLI.1 provider in the connection string.
This is far from ideal as I want to be able to distribute the spreadsheet without having force the user to install the SQL Server client libraries. I would have thought that installing the latest version of MDAC would solve the problem, but it seemed to make no difference.