All you need is the IBPhoenix ODBC driver and a reference in Excel to the
latest ADO library.
Connection string will be like this for a DSN-less connection:
Driver={Firebird/InterBase(r) driver};
Dbname=FullDBPath;
PWD=Password;
UID=Username;

Doing a Google for ADO Firebird connectionstring will get you more
information.

RBS

_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of pabloagogo
Sent: 23 March 2010 17:45
To: firebird-support@yahoogroups.com
Subject: [firebird-support] About Firebird and Excel VBA




Hi There,

I would like to use Excel as a data entry grid front end,
and use Firebird as a backend.

Using Excel VBA-ADO, what is required to connect to Firebird(lets say in
Server mode), create a database file and populate it.

What is the connection string required from VBA?

Any help is appreciated.
(By the way, can Firebird be used in an embedded mode, in Excel VBA?,
is there any .dll file that can be used. I know that there is that kind of
mode when I did a java app with JayBird).

Sincerely,

Pabloagogo






[Non-text portions of this message have been removed]