Open-AudIT
https://www.open-audit.org/phpBB3/

Connecting Excel to your MySQL database
https://www.open-audit.org/phpBB3/viewtopic.php?f=5&t=2216		 Page 1 of 1
Author:  shanimal [ Thu Apr 19, 2007 4:45 am ]
Post subject:  Connecting Excel to your MySQL database
Here is a great 'how to article', here is the description:

[quote]In cases where business applications have been built on open source databases, it may be necessary to connect other Windows applications, such as Microsoft Access or Excel, to these databases for reporting or business intelligence purposes.

One potential application of this process is to use Excel as a front-end for data analysis. Data can be pulled from views or tables and then further analyzed, graphed, and the like. Even pivot tables can be used to create even more powerful reporting solutions

This could be handy for those using Open-AudIT or WINventory (like me). I plan to try this later.

Here is the link

[url]http://port25.technet.com/archive/2007/04/10/connecting-office-applications-to-mysql-and-postgresql-via-odbc.aspx[/url]
Author:  A_Hull [ Thu Apr 19, 2007 5:59 pm ]
Post subject: 
I wrote a small article a long time back showing how to connect Open Office to Winventory. I'm sure I still have it somewhere, so if I have time I may dust it down and update it for Open-Audit and OpenOffice 2.X.

The principal is the same, as the article you describe. However in the case of Open Office, you can also create forms using OpenOffice Base, the database engine, either using odbc or jdbc and access the data directly.

:lol:
Author:  shanimal [ Sat Apr 21, 2007 1:11 am ]
Post subject: 
Hey, I like that idea even better! Thanks
Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/