You may use either, but this document briefly covers the use of DAO, and DAO will be discussed in more detail in lecture using the northwind.xlsm file as an example. The other library available - that is discussed in the text - is the ADO (ActiveX Data Objects). ![]() The examples in the Northwind spreadsheet use the DAO (Database Object) Library from Microsoft. In order to make your VBA code work with Access, reference the library: Microsoft Office 14.0 Access database engine Object Library. A spreadsheet that connects to this database is at. If you need a sample Access database.ĬP212: Sample Database - Northwind > 02:05 CP212: Sample Database - Northwind You may download the Access Northwind database from. I can't speak to Northwind.mdb (Access database) but, since you posted this question to a SQL Server forum, perhaps you are looking for SQL Server sample databases. ![]() AFAIK the download of the Northwind MS Access database isn't any longer available. Once we download SQL2000SampleDb.msi file right click on that and install it like. First we need to download available SQL2000SampleDb.msi file from this location Northwind and Pubs Sample Database 2. ![]() To install northwind and pubs sample databases in sql server 2008 you need to follow below steps 1.
0 Comments
Leave a Reply. |