Excel VBA x Interbase / Firebird

  • Thread starter Thread starter Mauricio Harger
  • Start date Start date
M

Mauricio Harger

Hi,

I would like to develop an application in Excel VBA that uses as database
Interbase or Firebird. I would like to do this because I have already
achieved Excel line limit and need to go further. Is it a good option? Does
anybody know where can I find more information about this? Will it be fast?
Is there any other option? Can I use Access instead of Interbase and query
data using SQL commands? Thanks,
 
Mauricio Harger said:
I would like to develop an application in Excel VBA that uses as database
Interbase or Firebird. I would like to do this because I have already
achieved Excel line limit and need to go further. Is it a good option? Does
anybody know where can I find more information about this? Will it be fast?
Is there any other option? Can I use Access instead of Interbase and query
data using SQL commands?
Click to expand...

It's a good idea to separate the data from the presentation layer. You
will find more into about Excel with MS Access (i.e. because they are
both MS products) than you would for Interbase or Firebird. Great
places to look are MSDN and the Usenet archive for this newsgroup:

http://groups.google.com/groups?group=microsoft.public.excel.programming

Keywords to search on are ADO and Jet (MS Access is a GUI front end
for Jet, the underlying data engine).

--
 
Mauricio,

This works very well.
I have developed an Excel add-in that works with ADO to query an Interbase
database.
The GUI is through a userform. Then once the data has been collected with
SQL and ADO the
further manipulation is done in arrays and eventually dumped to the sheet.
You may have to do quite a bit of tinkering with the SQL statements to get
it up to speed as
Interbase doesn't always choose the right plan, but if have you have done
this it can be very fast.
We use this on a network and even on Terminal Services and all works fine.

RBS
 
Back
Top