Ms sql server 7 text export issue
Posted on 2014-11-03
Am exporting data from a sql 7.00.842 server running on Chinese windows be 4.0 server, build 1381 sp6. Db codepage is cp950 though the text is all English, with some ref tags in the longer data.
When exporting using the data export wizard, I'm seeing a 2xxxxxx length text field output to comma delimited CSV, with or without enclosing quote marks. It will only output as ANSI, no unicode.
Opening the text file in excel 2007 I'm not seeing the normal CSV import wizard, opens straight into a sheet... The last longer field T the end of the record with rtf tags (several preceding fields of similar size and content appear to be unaffected so far) is merged with the first field which is a unique record identifier number.
It's a pretty old box so I'm reluctant to tinker with it until I understand better what the issue could be.
Any pointers or suggested fixes greatly appreciated...