Opening CSV File gives "SLYK" error
Praj 08 Jul 2009 01:49
A CSV file created by an SQR using the information in generating a CSV file form SQR was giving me the following error:
SYLK: File format is not valid
Turns out that this is a known issue with Excel as reported in this Microsoft KB article (323626).
If the first two characters in your CSV file are a capital I followed by a capital D (ID) the error occurs. Change this and the error goes away. You can either change the name of the header field or use lowercase id.