• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

Query Analyzer ntext data fields spilling into adjacent column when saving data

There appears to be no pattern as to when the "spillage" occurs, but when I return a query where fields have a datatype of ntext or text, running the query presents the data properly, however, when you click SAVE, then look at the resulting CSV files, many times the data is inexplicably pushed into the next 1 or more columns.

Has anyone seen this? How can I get clean data into a CSV file from this type of field? My output MUST be in CSV format for the "receiving" application.
1 Solution
could it be that your text has commas in it?
If it has to be csv then make sure the fields are surounded by "

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now