Re: [pysqlite] Converting SQLite database

Michel dos Santos Mesquita wrote:
> Hi,
> 
> I'm new to SQLite and I have been reading some books/website about it.  
> I am going to create a database in SQLite, but I'd like to have this  
> db available to other users. These are users who are not familiar with  
> SQLite, but with Microsoft Access.
> 
> So, I would like to ask two questions:
> 
> 1) Is it possible to open an SQLite db in MS Access?

MS Access can open any database via an ODBC link. And there's an ODBC 
driver for SQLite. So it is possible.

> 2) Is there a program/function to convert from SQLite format to mdb  
> (MS Access) format?

Not directly, you'd have to write one yourself, which wouldn't bee too 
difficult because there are Python libraries for accessing both.

Evaluating all this you might come to the conclusion that it's better to 
skip SQLite and just use the JET engine directly from Python. Features 
are probably comparable to SQLite anyway.

I'd use this library: http://adodbapi.sourceforge.net/

It's a DB-API interface for any database accessible via Microsoft's ADO. 
  There's a link on the page to the connection strings where you'll have 
to look up the right one for MS Access.

HTH

-- Gerhard