|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hi all,
I want to connect to Firebird from Excel/Access/VBA through it's ODBC driver. How would i go about doing this? BTW I dont know anything about ODBC's. Many thanks in advance. |
|
#2
|
||||
|
||||
|
Basically you need to download and install Firebird's ODBC driver, then create an ODBC System DSN (Datasource) and connect to it from Excel/Access/Whatever ... (see this example, it's about Excel and MySQL but steps are quite similar)
__________________
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 Last edited by pabloj : August 8th, 2006 at 09:25 AM. Reason: typo |
|
#3
|
|||
|
|||
|
thanks. ill try that.
|
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Firebird ODBC |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|