[dzt]

Hello,

Here is an example of how to convert any database file, with OLEDB provider or ODBC driver, to SQLite, programmatically.

With a Command Line utility (DB2CSV, VB6 source and executable) you can run any SQL SELECT statement to any database and convert the result to CSV file.

After that you can convert the CSV file to SQLite database (CSV2SL3, BASIC4PPC source and executable)

This code is from a field service app I'm developping.

Attached are two zip files.
DB2CSV.ZIP: Visual Basic 6 source code and compiled app. Must have MDAC 2.8 installed and VB6 runtime files.
CSV2SL3.ZIP: Basic4PPC Source code and compiled app. Must have .NET 2.0 installed.

Regards,

Dimitris