I have a software that uses a Interbase Borland database (IB file).It's one file of 1,5 giga bytes.Is it possible to use Excel to send SQL commands to search in thisdatabase?
Not exactly sure!If Excels Query add-in can see the file as a data source, then I would say yes.I have ran Excel SQL against data sources such an Oracle, Lotus Notes, SQLserver, Access & Excel files.
See a thread from just a day or two ago "Pulling a name from an Accessdatabase and putting it in Excel" where SQL is used to query an Accessdatabase, write to it and add new records to it.That code can be used more or less exactly as is for non-Accessdatabases, you just need to change the connection string.