Hi, I?m trying to access a SQLite database I?ve written using Excel. In the Windows world we used to use ODBC drivers which were clunky, cumbersome, sometimes worked, sometimes didn?t, had arcane issues and generally were a PITA.
So I?m trying to do the same on our development Macs and it appears that ODBS on a Mac is clunky, cumbersome, sometimes works, sometimes doesn?t AND has the advantages of being old as well now :) Some of the ODBC?s out there were written for PowerPC which is around 10 years old. Whilst we could extract the data in SQL, manipulate it in Perl (stop sniggering at the back there), we?d prefer to use Excel, bring our data into a Pivot Table and work with it using the right tools. We don?t actually mind spending money (well we do, but we realise we might have to), but I wondered if anybody had any recommendations of things that they know work. We?ve seen these open sources ones http://www.ch-werner.de/sqliteodbc/ <http://www.ch-werner.de/sqliteodbc/> These paid ones http://www.openlinksw.com <http://www.openlinksw.com/> Actual Technologies <http://www.actualtech.com/> Simba Technologies <http://www.simba.com/> and various other websites for the Mac ODBC administrator application that was removed around five years ago. If we know that the open source ODBC stuff works we?ll put the time in and make it, however we?ve probably all got stories to tell of how we burnt a week getting some weird open source system thats now been abandoned and will never work on anything later than a 286 CPU. If we know that the Actual tech drivers ?just work? we?ll go and buy that. I?m more concerned about burning time than money. Thanks, Rob.
