I have a 2 step DTS package which creates a table in an
Excel spreadsheet then populates it from values in a SQL
A problem occurs when some columns contain null values.
It is as if the NULL columns from the source data are
ignored and the values from other columns are used instead
so that the data columns in the spreadsheet are shifted to
The platform is SQL Server 2000 and Excel 2000 running on
Windows 2000. Latest service packs all round!