How are you opening the file...

Double click, Excel-File-Open (*.csv), or Get data?

Perhaps a different method would work.


"MikeDb" wrote:

I have output from an application that I wish to view in excel (office 2000).
This output is in CSV format.

When I open the CSV file, excel puts all the text into a single cell instead
of into multiple cells on multiple lines.

The file contains the following text as part of a field:

The SQL statements should read ""INSERT INTO <table_name (<attribute1_name,
<attribute3_name, <attribute3_name) VALUES (<value1, <value2,
<value3);""

It appears that text between angle brackets (<) is being interpreted by
excel as HTML tags (if this is part of a large file, then an HTML error is
generated).
If I replace all "<" with "{", then the file opens correctly.

How can I stop Excel 2000 from trying to do clever stuff with the text?