I am using sqlServer2000 DTS for exporting data to Excel. It was all right until we have changed the server to Win2k sp2. Now when it passes Null values to Excel, the resulted table's rows(!) shrinks, and all Null values disappear. You can check the test at www.extra.hu/szantocs/DTSTest.zip (164 k) , one DB with 1 table, can be attached to SQL server's databases and then export w/ DTS to excel 2000)
Thasnks if some can help,