How to use Open Office Database in Cellica Database?

How to use Open Office Database in Cellica Database?

You can use Cellica Database for Open Office.

You need to use SQLite Database for connection with Open Office.

Please follow the following steps for to use Open Office Database in Cellica Database.


1.    Download and Install SQLite ODBC Driver from the following path,
      http://ch-werner.de/sqliteodbc/sqliteodbc.exe

2.    Download and put “SQLiteDB.sqlite” at your appropriate path.
      http://www.cellica.com/download/SQLiteDB.sqlite

3.    Create ODBC DSN for “SQLiteDB.sqlite” database using SQLite3 ODBC Driver.

4.    Connect OpenOffice to a SQLite Database using ODBC DSN created in Step 3.
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org#Connecting_OpenOffice_to_a_SQLite_database


5.    Create Tables in newly Created OpenOffice Database.

6.    Now use ODBC DSN created in Step 3 in CellicaDatabase application for Profile creation.

You can use following link for more information about Open Office and SQLite DB.
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org