SQLite data into Excel?

Question

Hello,

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?

Thanks.

Answer 1

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\"&gt;
<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.

Answer 2

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.