CODEWITHSUNDEEP
excelsqlite
Thomas Browne
Thomas Browne

Reputation: 24898

SQLite data into Excel?

I wish to pull data from a large SQLite database into Excel. I'll want to do so quite interactively so don't want to export CSVs or anything like that. I have seen the sqliteodbc website on ch-werner.de but does that work with Excel 2007?

What are the best options?

Upvotes: 1

Views: 2382

Answers (2)

Thomas Browne
Thomas Browne

Reputation: 24898

Actually I have gone through the ch-werner.de file mentioned in the question and it works well, even in Excel 2007. Simply make sure to register your database using the ODBC option in the Windows control panel.

Upvotes: 2

bcosca
bcosca

Reputation: 17555

Excel recognizes XML and the format is something like this:-

<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\" xmlns:html=\"http://www.w3.org/TR/REC-html40\">
<DocumentProperties xmlns=\"urn:schemas-microsoft-com:office:office\">

You might want to create a sample of the output you want in Excel, save it as XML data. Open your regular text edit, and voila... you got the XML skeleton.

Now programmatically converting SQLite to Excel, that's another thing. You didn't mention what language you're conversant with.

Upvotes: 0

Related Questions