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.