RE: Corrupted File Error when writing to an Excel File

Hi Thomas,

  Wrong forum.  This is the one you want:  http://tda.inside.quest.com/forumindex.jspa?categoryID=144

-John


From: [email protected] [mailto:[email protected]] On Behalf Of thomas_reed_875
Sent: Monday, October 10, 2011 10:37 AM
To: [email protected]
Subject: [toad] Corrupted File Error when writing to an Excel File



Message from: thomas_reed_875


I have a query running from Toad for Data Analysts 2.6.1.568. When I run it to a new file it works perfectly.  A little over 403,000of data from Banner.  But when I run it to an existing excel file andsend it to a specific sheet I get an error when I try to open my excelfile with the now updated data.

Thereason I have it load there, is I am using it to perform a basicDashboard on a Summary Sheet.  The data from 3 files on separatespreadsheets provide the numbers for my Dashboard.

Any Help is Appreciated


_______________________________________

Historical Messages


Author: thomas_reed_875
Date: Mon Oct 10 08:37:16 PDT 2011
I have a query running from Toad for Data Analysts 2.6.1.568. When I run it to a new file it works perfectly.  A little over 403,000of data from Banner.  But when I run it to an existing excel file andsend it to a specific sheet I get an error when I try to open my excelfile with the now updated data.

Thereason I have it load there, is I am using it to perform a basicDashboard on a Summary Sheet.  The data from 3 files on separatespreadsheets provide the numbers for my Dashboard.

Any Help is Appreciated

__
_______________________________________