Hi, So I guess there is no other way than ODBC way. I am trying to avoid that. I wish to just write code and not have to do any kind of configuring, like setting up a datasource in the windows controlPanel/Administrative Tools. I was hoping for a zero administration way of connecting excel to H2. I have eve seen the ODBC-JDBC bridge, but I don't like that solution either. Anybody no of any other way to get Excel-H2db to work together. Is there any commercial third party component that can possibly help.
OR Is there an easy way to use OpenOffice Calc and connect to H2. Because OpenOffice as of version 3.0 supports VBA. Paluee On Mar 22, 3:48 pm, Kerry Sainsbury <[email protected]> wrote: > You could start H2 in server mode and connect to it via the ODBC > driver:http://www.h2database.com/html/advanced.html#odbc_driver > > Cheers > Kerry > > On Tue, Mar 23, 2010 at 7:25 AM, Paluee <[email protected]> wrote: > > Hi there, > > > I know this is a Java based database. > > But is there a way using Excel VBA using ADO to create and > > use H2 database. > > > I would like to use H2 database as a backend for Excel app, because > > Excel is a good data entry GUI for the work that I do. > > > Paluee > > > -- > > You received this message because you are subscribed to the Google Groups > > "H2 Database" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<h2-database%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/h2-database?hl=en. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
