Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-28 : 11:45:49
|
| Donna writes "I have a sort of anomaly in that I get different positional results when I export the results to a text file rather than Excel. If I export to Excel, I get field a in its own column and field b in its own column – always. If I export to a text file with fixed width, I get varying results. If both fields are present, all is cool. If field a is missing (i.e., value is null) but field b is there, field b starts where field a should have started - therefore, there is no placeholder for a field. I played a little bit with transform thinking it might help but it did not seem to. Have SQL 7.0 and am running export on Win95." |
|
|
|
|
|
Exporting fields with nulls to text file