Null values exporting to Excel

Null values exporting to Excel

Post by John » Fri, 27 Apr 2001 01:25:50

I am exporting a table from SQL7 to Excel using DTS.
(I have also tried using BCP and through an Access.)

When I export to excel, some of the rows have null values and the data in the row
will shift to the left one column whenever this happens.  I have resized the
columns to ensure that they are in the wrong columns.  I have also exported to a
text file and then imported to excel and there is no problem with the null values
and the following columns align properly.

Anyone know a reason or a bug that is causing this problem and hopefully a way to
solve this problem and export directly to excel.

Thanks in Advance


1. Export Null values to Excel cause left shifted values in XLS

With DTS, I export a table with some Null values.

In the resulting XLS file, for a Null value, instead to have the cell blank,
the cell is filled by the value of the just right column ; and all the next
values of the row are shifted to the left.

How to make correspond a Null value with a blank cell ?


2. DOS --> MAC problem

3. adodb connection to excel: recordset.fields(i).value=null for fields with numeric value

4. Install SQL7 on Win2K Pro laptop (non-server)?

5. Export to Excel - problem with NULL

6. Images and ASP

7. Column display null while exporting from Excel Through DTS

8. ODBC - updateable cursors

9. SQL 2000 DTS export to Excel problem with Nulls

10. Null values: Classic null value problem (?)

11. DTS Export: How to have nulls export as blanks on fixed width export

12. excel null values!?

13. Null Values in Excel Recordset