Excel 2010 DSN-less connection to SQL Server

I am sure this question must have been asked before but I haven't found any answer on the web.

How does one create a dsnless connection string in Excel 2010 in order to access a sql-server database?

An example would help a lot.

I assume this can be done with the connection wizard, but if not then where should the connection string be stored and how does it get recognized by the workbook? I would prefer to identify the SQL Server by its IP address.

Thanks for any help.

0 answers