Foxpro dbf to SQLITE 2

[tilltek]

Is there a way to easily convert DBF files to SQLITE files and back?
From within Foxpro if possible.
Note that I need SQLITE files , not SQL.

Ken

 

[r0gerc]

There is the SQLite Manager add-in for Firefox which claims to create a table from a CSV file and there are some converters at sqlite.org, some free some not. I did it once using SQLite Manager for Firefox, but I wouldn't say it was easy, I think I had to create the SQLite tables manually and then import the data afterwards. I hope this helps,
Roger

 

[Olaf Doschke]

Simply look out for an SQLite ODBC driver. Having that SQLite can be adressed like any other database via SQLPassthrough functions. For sure you have to build the database, which may be the "hardest" part, but it's not hard to generate CREATE TABLE statements from Foxpro, using AFIELDS() info, is it? Look into the SQLIte docs, what fieldtypes exist and how it's syntax differs from ANSI or foxpro SQL.

Bye, Olaf.