1
There is an InterBase database that I'd like to connect to using Excel. I have the database name, address, and login info. IB, as I understand it, is a form of SQL.
Using the SQL connect mode under "Data" in Excel does not work, however. I would guess that I need some kind of driver to go between the two as InterBase is proprietary.
I can successfully ping the server, so I know it's there. I have verified that the login info is correct.
What steps do I need to take to get Excel to work?
This may help http://office.microsoft.com/en-gb/excel-help/create-edit-and-manage-connections-to-external-data-HA010167227.aspx I assume you have the drivers installed on the machine?
– Dave – 2013-11-01T15:44:01.103