Home > Forum Home > Automating Data Analysis Tasks > Send variables to MSQuery via entry in Excel cell range? > Set-up Northwind DSN Share

Set-up Northwind DSN

Excel Help for Set-up Northwind Dsn in Automating Data Analysis Tasks


Forum TopicLogin

Set-up Northwind Dsn

Rate this:
(3/5 from 1 vote)
ShockedThe 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 on
 
View Full Post

Find relevant Excel templates and add-ins for Set-up Northwind DSN in the