Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Is it possible to use Excel to send SQL commands to search in this database?

  Asked By: Kelley    Date: Aug 19    Category: MS Office    Views: 756
  

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 this
database?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Adelaide Fischer     Answered On: Aug 19

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, SQL
server, Access & Excel files.

 
Answer #2    Answered By: Blake Smith     Answered On: Aug 19

See a thread from just a day or two ago "Pulling a name from an Access
database and putting it in Excel" where SQL is used to query an Access
database, write to it and add new records to it.

That code can be used more or less exactly as is for non-Access
databases, you just need to change the connection string.

 




Tagged: