Home > Forum Home > Automating Data Analysis Tasks > Send variables to MSQuery via entry in Excel cell range? > Set-up Northwind DSN | Share |
Forum Topic | Login |
Set-up Northwind Dsn | Rate this: (3/5 from 1 vote) |
The VBA code in the example assumes that there is a DSN set up for the Northwind database. Northwind is an example database that ships with Microsoft SQL Server. To DSN must be set up (named "Northwind") to connect to an SQL Server with the default database being Northwind. To do this go to Control Panel > Administration Tools > Data Sources (ODBC) and Add an SQL server DSN accordingly. | ||
Excel Business Forums Administrator | ||
Posted by Excel Helper on |
View Full Post |
Find relevant Excel templates and add-ins for Set-up Northwind DSN in the Excel Business Solutions Directory |