> I have about 25 databases that I need to run the same query against that > returns about 5 columns of information. > > I need this information then published within an Excel spreedsheet. > > What is the best way do handle this? > > Currently, I'm running each query manually, copying/pasting the result > to Excel, and repeating... > > I need to run this procedure every week, and it takes a considerable > amount of time.
In that case, I suggest automating it with a small program. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]