SQL database (was Re: [ot] the year is 1982)

Chong Yu Meng chongym
Sat Mar 31 00:25:18 PDT 2007


On Sat, 2007-03-31 at 13:24 +1000, Keith Antoine wrote:
> The database is an early windows NT4 version, so I guess its M$, what we 
> need is to get the database
> in a CVS or txt format so as we can re-enter it into a new medical alert 
> program and XP as an OS.

Uh-oh ! You forgot to mention something about Linux! That would push
this post to General, under the new rules. But before that happens, let
me just take a stab at answering this ...

Your best bet is to use MS Office (ugh!) because someone would probably
have the ODBC connection already setup. Specifically, you will need
Excel and you need to configure Excel to use an ODBC connection to the
database to extract the data and dump it into the spreadsheet. Here's a
useful link :
http://help.lockergnome.com/office/SQLite-Excel-ODBC-ftopict704125.html

Hope this helps! 

Of course, accessing data in Linux is a lot easier !

Regards,
pascal chong




More information about the Linux-users mailing list