Andy@

Bizarre Error with CSVs in Excel:- SYLK: File format is not valid

From Microsoft help (http://support.microsoft.com/kb/323626):-

When you try to open a text file or a comma-separated variable (CSV) file, you may receive the following error message:-

	SYLK: File format is not valid

This problem occurs when you open a text file or CSV file and the first two characters of the file are the uppercase letters “I” and “D”. For example, the text file may contain the following text:

	ID, STATUS
	123, open
	456, closed

Note This problem does not occur if the first two letters are lowercase “i” and “d”.

Surely I’m not the only one to find this utterly insane!