Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
folettra
Starting Member
15 Posts |
 Posted - 2006-11-02 : 21:02:54
|
| I am running SQL Server Standard Edition Version 8.00.2039 (SP4)SQL Enterprise Manager version 8.0Excel 2003 version 11.8105.8107 SP2I use DTS to export data to a specific table in a specific excel file. In the excel file I have data tabs and presentation tabs. The data tabs are fed by the DTS package. The presentation tabs have formulas that reference the data tabs.I use Execute SQL tasks to Drop and recreate the table headers in the excel data tabs.I then use the Transform Data task to export the data to the specific data tabs.The package runs fine until I decide to add another sheet into the excel template from excel. After that when I drop the first table, the excel file becomes corrupt. I get an error that says the file is not in the expected format.When I open the excel file I get an error that says corrupt file data may be lost. I click ok until the file opens and I see that, at random, data is moved from one tab to another. Some of the headers in the data tabs show the word VALUE.Does anyone know whey this might be happening? |
|
|
|
|
|
Corrupt excel file after drop table