Thursday, 17 January 2019

openoffice - Database access through odbc driver and excel


Is it possible to access a database via ODBC and access this in MS Excel or OpenOffice, then exporting the database into a flat file?


The program I am accessing data only allows an ODBC connection in. Not sure what database it is.



Answer



In Excel 2003, click on Data -> Import external Data -> Import Data.


alt text


Click on New Source, ODBC DSN and select choose your ODBC connection


alt text


-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...