[PLUG] MS Access -> ? for OOo

[Rich Shepard]

On Sun, 10 Feb 2008, John Jason Jordan wrote:

> But then OOo can't read Kexi data either - evidently Kexi uses "SQLite
> format 3."

   That's SQLite version 3. The internal format did change from version 2.

> According to the literature OOo Base is supposed to be able to read SQL
> and open document formats, but SQLite doesn't seem to be on the list. At
> the same time, the only format Kexi can export to is .csv. Around and
> around I go.

   If Kexi stores the data in an embedded sqlite database then you're ahead
of the game.

   There's probably a Ubuntu package for SQLite-3.5.5 (that's the latest
version, released last week and it uses registers rather than the stack).
Install it. Look at the file names that kexi uses; there should be one that
represents the database. On the command line, type:

sqlite <filename> [Enter]

   Once the database is open, look at the help file to see all the ways you
can look at the database:

sqlite> .help [Enter]

   You can change the separator, export the file using different delimiters,
and so on. You can see the tables using the .table command, check the schema
for a table using the .schema command, and so on.

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863