Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

My GPS uses a SQLite database. I would like to access this data using OpenOffice to look at the relationship between data entries. Is there a way to install SQLite with OpenOffice?

share|improve this question
    
There has been discussion about supporting SQLite as LibreOffice Base's native backend (instead of HSQL). Not sure whether this went anywhere. –  Mechanical snail Oct 24 '12 at 0:18

2 Answers 2

up vote 10 down vote accepted

I think OpenOffice.org should be able to use the libsqliteodbc Install libsqliteodbc ODBC driver, but I have never tried it.


Edit

Okay, I tested it and will explain how to do it...

If you click the icon above to install libsqliteodbc, make sure that you also install the AddOn “Graphical tools for ODBC management and browsing (unixodbc-bin)” (so, make sure the checkbox is ticked).

Now press Alt+F2 to launch the Run application dialog window and run ODBCConfig. In the first tab "User DSN", press the "Add..." button.

screenshot ODBC Data Source Administrator

You will get a "Select a driver..." dialog. Select the SQLite (version 2) or SQLite3 (version 3) driver as appropriate, then press the "Ok" button.

screenshot Select a driver...

Now you can set up the properties for the actual ODBC Data Source. Fill in the Name field (use whatever descriptive name you want, it's there for your convenience). Fill in the Database field (use the small > button to browse & select it). Leave all the other fields alone. Press the checkmark button screenshot button to save this Data Source.

screenshot Data Source Properties

After this you should see your new Data Source in the ODBC Data Source Administrator and in OpenOffice.org.

In OpenOffice.org select the option to connect to an existing database, select ODBC from the drop-down, then press "Next". Now you should be able to select your newly-created ODBC source when you press the "Browse" button...

share|improve this answer
    
This is wonderful. I have been using the previous links for days trying to do this and you were able to fix it in a few hours. Thank you so much! –  RunningUtes Nov 1 '10 at 6:37
1  
In (K)ubuntu precise ODBCConfig is not available. Use ODBCManageDataSourcesQ4 instead. Basically the same.. looks just a bit different. –  Manwe Jun 30 '12 at 18:32

You can use SQLite Manager extension for Firefox to open the database and export it as CSV,SQL or XML. I'm sure you will be able to import one of those formats into OpenOffice. However, the extension itself is enough to view and manage data inside the database. There is no need to import to OO.

alt text

If you don't want to use Firefox for that, then use a standalone application:

sqlitebrowser Install sqlitebrowser

share|improve this answer
    
that's a cool extension, gonna look it up now you mention it =D –  RolandiXor Oct 31 '10 at 22:18
    
@Roland Taylor I can't live without it :) –  lovinglinux Oct 31 '10 at 22:23
    
just installed it =D –  RolandiXor Oct 31 '10 at 22:26
    
@Roland Taylor you can launch it on a new widow or new tab. –  lovinglinux Oct 31 '10 at 22:28
    
+1 useful answer, I use this extension frequently myself, my second choice is Sqliteman. –  Sabacon Oct 28 '11 at 18:44

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.