Subject | AW: [firebird-support] Using Firebird with MS Access |
---|---|
Author | Olaf Kluge |
Post date | 2013-02-11T11:46:42Z |
Hi,
..
Hello all,
I had previously posted about ODBC drivers, but I didn't understand how to
solve the problem, so trying it again.
I have Windows 7 64 bit, MS Office 32 bit version installed on 64 bit
machine. I want to data from a database with extension .gdb into to MS
Access.
I am told I will need ODBC driver for this.
I am unsure which driver should I download, how to install it and then how
to import the data.
I don't know anything about databases and other complexities, so I will
greatly appreciate simple steps to get this done.
regards,
Himanshu Bahirat
..
I try to help you.
You can download and install the 32Bit ODBC Driver from firebirdsql.org.
After this, you should create a system dsn, please run
C:\Windows\SysWoW64\odbcad32.exe (for 32 Bit, the 64Bit located in the
control panel does not work für 32 Bit Access. Set a name for your
connection and fill in all fields on the configuration page. You should use
the fdb extension for your firebird database.
Than you can link the tables in msacces after select the system dsn. For
running stored procedures directly in ms access you can use a adodb
connection. You can also import the data, but in this case the data are not
linked, but fix imported.
Good look.
Best regards.
Olaf
[Non-text portions of this message have been removed]
..
Hello all,
I had previously posted about ODBC drivers, but I didn't understand how to
solve the problem, so trying it again.
I have Windows 7 64 bit, MS Office 32 bit version installed on 64 bit
machine. I want to data from a database with extension .gdb into to MS
Access.
I am told I will need ODBC driver for this.
I am unsure which driver should I download, how to install it and then how
to import the data.
I don't know anything about databases and other complexities, so I will
greatly appreciate simple steps to get this done.
regards,
Himanshu Bahirat
..
I try to help you.
You can download and install the 32Bit ODBC Driver from firebirdsql.org.
After this, you should create a system dsn, please run
C:\Windows\SysWoW64\odbcad32.exe (for 32 Bit, the 64Bit located in the
control panel does not work für 32 Bit Access. Set a name for your
connection and fill in all fields on the configuration page. You should use
the fdb extension for your firebird database.
Than you can link the tables in msacces after select the system dsn. For
running stored procedures directly in ms access you can use a adodb
connection. You can also import the data, but in this case the data are not
linked, but fix imported.
Good look.
Best regards.
Olaf
[Non-text portions of this message have been removed]