Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
OPENING TWO DIFFERENT EXCEL PROGRAMS | Excel Discussion (Misc queries) |