I am trying to export data from a SQL Server 2000 DB to an Excel worksheet. I am using DTS with SP3a and am having a problem with NULL values. To be specific, I have a 4-column table. Several rows in this table have <NULL> as the value in the third column, with pertinent data in the 4th column. When I export to Excel, I end up with four column headers, but all the data is compressed into the first three columns. Rows which had a NULL value for column three now have the column4 value in the column3 cell. Column4 is empty in this case. Only rows which have values for both column3 and column4 are correct

This appears to be the exact same problem as http://support.microsoft.com/default...n-us%3BQ294410 - but this article pertains only to the Jet engine (Access)

Please let me know if you have any suggestions. Thanks!

Scot

Do none of the fixes offered work for you though ?

Version of Excel.?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"sshapiro (AT) iisystems (DOT) com" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message news:E093E4A2-F090-48FF-A8CB-9B21C0011BCE (AT) microsoft (DOT) com...
values. To be specific, I have a 4-column table. Several rows in this
table have <NULL> as the value in the third column, with pertinent data in
the 4th column. When I export to Excel, I end up with four column headers,
but all the data is compressed into the first three columns. Rows which had
a NULL value for column three now have the column4 value in the column3
cell. Column4 is empty in this case. Only rows which have values for both
column3 and column4 are correct.
this article pertains only to the Jet engine (Access).