How to use DBI Module
-
I was wondering if someone knows how to use a DBI to exec a sql script and copy the data collect to an Excel Spreadsheet?
What Database you ues? If you use sql server,You can do it with a simple export with Intergration Service of SQLServer.
Human knowledge belongs to the world http://www.rad.pasfu.com/index.php
-
I was wondering if someone knows how to use a DBI to exec a sql script and copy the data collect to an Excel Spreadsheet?
If you're using SQL Server there's a plenty of good articles about this on CodeProject: http://www.codeproject.com/info/search.aspx?artkw=sql+AND+server+AND+query+AND+excel&sbo=kw[^] For example this could be a starting point: http://www.codeproject.com/KB/vb/exportdatabasetoexcel.aspx[^]
The need to optimize rises from a bad design.My articles[^]
modified on Tuesday, January 20, 2009 4:17 PM