Database Related Questions - Why do I get an error from Excel when I open an ASCII file?

Excel generates an SYLK error sometime when an ASCII file is loaded. It does this because the first field name in the first column has the value ID. You must change the value or change the position of the column. Excel tries to open ASCII files with the default SYLK file type. When Excel sees ID, it tries to look for the file type parameter. Since tab delimited and comma delimited files are not formatted in this way, Excel shows the SYLK error message.