MDAC explained (ADO version 2.5, 2.6, 2.7, and 2.8)

Microsoft Data Access Components (MDAC) include three technologies for accessing data: ActiveX Data Objects (ADO), OLE DB, and Open Database Connectivity (ODBC).

OLE DB

Microsoft OLE DB is a set of COM interfaces that expose data from a variety of data sources including a bridge to ODBC to enable continued support for the broad range of ODBC database drivers.

ADO

ADO is an interface to OLE DB. It provides access to a variety of database systems and data structures through the OLE DB data provider.

ADO version and Windows

MDAC ships with the Windows operating system. Applications that use ADO can make use of the default version of ADO on the target Windows system. The following is a list of the default ADO versions that ship with Windows:

Windows	ADO
Windows 98	ADO 2.1
Windows ME	ADO 2.5
Windows 2000	ADO 2.5
Windows XP	ADO 2.7
Windows 2003 Server	ADO 2.8

Visit http://msdn.microsoft.com/data/ for more information about ADO and MDAC downloads.

To use XlsToSql, you need install MDAC version 2.8 from:

http://msdn2.microsoft.com/en-us/data/aa937730.aspx

http://www.download.com/3001-2404_4-10281285.html?spi=9c0ff79b64718e43ae4d795ed3dbd826&idl=n

XlsToSql is a data conversion tool that helps DBA and database programmer import Excel data to SQL Server database.

30-day free trial

US$59.95