Smart-IT ODBC Driver Setup for Excel

Vincent Blaauw Features
Please Share

geometric shape digital wallpaperNeed to Export certain information from Smart-IT directly to Excel regularly?

You can with a Firebird ODBC Driver.

Today we will be looking at how to set this up correctly.

Firstly we need to download the Driver.

You need to check whether you are using the 32bit or 64bit version of Microsoft Excel first and then use the appropriate link down below and install the driver.

For 32 Bit Excel use the following link
https://sourceforge.net/projects/firebird/files/firebird-ODBC-driver/2.0.5-Release/Firebird_ODBC_2.0.5.156_Win32.exe/download

For 64 Bit Excel use the following link
https://sourceforge.net/projects/firebird/files/firebird-ODBC-driver/2.0.5-Release/Firebird_ODBC_2.0.5.156_x64.exe/download

Once installed, we need to set up the DSN record.

  1. To do this, open up the Windows Control Panel, then Administrative Tools.
  2. Open ODBC Data Sources (Again select appropriate Architecture).
  3. Click on the System DSN tab and click on the Add button.
  4. Select the Firebird/Interbase(r) driver and click on Finish.
  5. The ODBC Setup Screen will now appear.
  6. Type in the desired name in the Data Source Name (DSN) Input field
  7. (This is the name that will appear in Excel)
  8. Type in the desired description in the Description Input field.
  9. Click on the Browse button next to the Database Input field.
  10. Browse to the database you want to use, select database and click on the Open button.**Note that Smart-it databases are under C:\smartitplus_databases.
  11. Next click on the Browse button next to the Client Field, select the fbclient.dll and click on the Open button.**Note that fbclient.dll is under C:\Program Files(x86)\Smart-It+ 2.0\Backend\fbclient.dll.
  12. Type in the Database Account as SYSDBA in the Database Account Input Field.
  13. Type in the Password as MASTERKEY in the Password field.
  14. Press the OK button.

The connection should work correctly now.

To test in Excel

  1. Open up a new spreadsheet in Microsoft Excel.
  2. Click on the Data Tab, select the dropdown menu Get Data, go down to From Other Sources, and select From ODBC.
  3. The From ODBC screen will now appear.
  4. Select your created DSN source and press the OK button.
  5. All the Tables of the database will now appear.
  6. You can either select the desired table or tables and create a Power Query or you can insert a Firebird SQL script under the Advanced Options section in the previous step.

We will be covering both these options in future Articles.

Please contact us if you require further assistance.