Link&Populate OOCalc "Table Control" to OOBaseDB using Macro

[shrikant_US]

Hi,

I have OpenOffice 2.4 installed on my PC and I have a database called "ProjectDB" created in OOBase having "TblProject" table on SQLite. I have created DSN called "DSN_ProjectDB" through ODBC Connection that connects to "ProjectDB".
I could connect to this database through ODBC from OOCalc worksheet, using macro. (Refer "http://user.services.openoffice.org/en/ ... =13&t=6452" with subject : "[Solved] OOBase DB connectivity thru ODBC using OOCalc Macro" for the code)

Moreover, I have one "Table Control" named as "TbCtl_Project" created in OOCalc worksheet. "TbCtl_Project" has two columns (i.e. ProjectID, ProjectName). This control is linked to "TblProject" of "ProjectDB" Database.

I want to establish the database link of "TbCtl_Project" and populate the records, dynamically, using Macro.
Could anybody could help me doing this?

Regards,
Shrikant

[DrewJensen]

so you want to want to take values from cells in the spread sheet and popluate the SQLite table with the values - this is the macro you want?