Skip to Content
0
Former Member
May 12, 2009 at 01:02 PM

Corrupt CSV file in scheduler

39 Views

Hi

I have a file which runs in scheduler daily. There is usually no problem with this file, the scheduler creates the CSV and this contains the correct data, can be opened successfully by users, etc. However, sometimes a corrupted CSV file is created. The file is not 0 size (53KB for the latest file), and when the user tried to open in Excel, the following error is displayed "Excel found unreadable content in 'cash.xls'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes." If you click Yes, following message is displayed:

Repairs to ;cash(2).xls'

Excel was able to open the file by repairing or removing the unreadable content.

Excel recovered your formulas and cell values, but some data may have been lost.

Excel found errrors that may cause some recovered data to be put in the wrong cells. Please check your recovered data carefully.

When you click Ok, there is then no data in the file, there is not a single cell in Excel which has data.

Has anyone experienced this before?

Thanks.