|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
August 6th, 2006, 10:55 AM
|
|||
|
|||
|
Manipulating a Firebird application using VBA
Hi all,
Theres a progam created using Firebird as described here: http://www.lasa.org.uk/aims/aims_what.shtml#version I want to be able to enter data into the firebird application from an Office application (e.g. Excel) using VBA. I want to also be able to extract data from the application using VBA. Does anyone know how i can do this please? Many thanks in advance!! Regards AM
|
|
#2
August 6th, 2006, 11:42 AM
|
||||
|
||||
|
You can connect to Firebird from Excel/Access/VBA through it's ODBC driver, see the sticky "resources" on top of this forum for the download link.
BTW: Nice to see another professional user of Firebird
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#3
August 6th, 2006, 12:30 PM
|
|||
|
|||
|
Thanks
Thanks for the quick reply. Im afraid i am only an beginner VBA programmer - and therefore i dont know what an ODBC is. i cant make sense of the information at the link you provided.
Could you give me an example please - of how i could use the ODBC driver? Thanks again.
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Manipulating a Firebird application using VBA |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
