Connecting VBA to HSQLDB

[Hamzaaton]

Hey all,
I'm developing a Java app that calls a Macro.
Is there anyway how to connect to HSQL DB table and insert data in it with VBA code ?

[Norie]

Can't you use the Java app to connect to the database and insert data?

[Hamzaaton]

Thx for the reply,

The Java app will create the DB, call the Macro that inserts the data, then fetch the DB.

So, I have to get the Macro connected to the HSQL DB. :/

[Norie]

Why do you need the macro?

Can't everything be done in the Java app?

[Hamzaaton]

Norie, the only way to get FormField Text Input and Checkboxs' value I figured out is via Macros. I've a MS Word file full of Checkboxs to extract their values.