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.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Corruption of Excel data after exporting from SQL

Author  Topic  281724 Starting Member 1 Post Posted - 2007-11-23 : 00:39:29 I came across to your answers on one of the Google group Forum replying to Excel problem I'm having excel sheet loaded with charts and Macros, and having some predefined data in few worksheets of same file. After exporting data to that excel sheet from SQL Server 2005 using SSIS, excel sheet shows all the corrupted data. Even it modifies existing worksheet's data. On opening the file it shows the error "File error: data may have been lost" multiple times. I haven't written any macro On Save Can you please let me know what could be the problem and its solution? I would appreciate your early response.