SQL Excel

Before downloading, please make sure you can comply with the installation prequisites. 

Note on Insallation Prequisites, the Installation Package does not install the Microsoft Data Access Component (MDAC) or the Microsoft XML Parser (MXSML) - both of these are necessary for the add-in to function. This is deliberate as the installation package has been kept very simple. The application consists of a one DLL (SQLExcel.dll  - approx size is 200k) and one settings file (Connection_Settings.xml). Most relatively recent builds (XP or later) will have these components on them already but you need to check this first.

Installation Prequisites:

- MDAC 2.5 or more recent.    If you are using Windows 2000, then MDAC 2.5 or greater is already installed. Otherwise, you should check the MDAC version on your machine by running regedit (Start->Run..., enter regedit.exe) and check the "FullInstallVer" value under the key HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess. It should be 2.50.x or greater.  You can download an updated version here, Microsoft Data Access Component 

- MSXML 3.0 MSXML3 or more recent.  The MSXML Parser is used in the  add-in only to talk to the settings file (Connection_settings.xml) which is in XML format.  But it is still needed.. This is a standard Microsoft component and on typical builds,  but if you dont have it you can read more about it and download it here -  MSXML Parser Download Link.

- The core file of the add-in - SqlExcel.dll needs to be registered on your machine so you need privelidges to register a DLL.

Download Instruction

(1) Close out of all of instances of Microsoft Excel.

(2) Download the SQL_Excel_Setup.zip file to a temporary folder on your machine.

(3) Extract the contents to a temporary folder (you can delete this after the installation).

(4) Run the Setup.Exe from your temporary folder location.

(5) Re-open Excel and you should be all set (there will be no database connection configured and you will get a message notifying you that you need to set one up when you hit the first button on the SQL Excel Toolbar).

(6) Optional but recommended - Excel Security Settings should be set up "Medium" level.  On the Excel menu select TOOLS and then select OPTIONS and then go to the "Security" Tab and hit the "Macro Security" button.  Then (i) On the "Security Level" tab - set to "Medium" and (ii) on the "Trusted Sources" tab" - "Trust all Installed Add-ins and Templates" and "Trust access to Visual Basic Projects " should both be checked.  Setting Excel up like this will get rid of the "Macro Security" warnings when the add-in is loaded.

  Download the zip file (file has been checked for spyware/viruses by Download.com and you will download from Download.com)  here    

-