DTS Export: How to have nulls export as blanks on fixed width export 
Author Message
 DTS Export: How to have nulls export as blanks on fixed width export
I have tried to export from a table that has some null values, to a
fixed-width text file.  I would like fields that have nulls to output as
all blanks.  (MS Access will do this when I use a Import/Export
specification.)  But these fields do not output as blanks, thus the data
gets shifted.

Any solutions?

TIA,
Dewey



Sun, 30 Sep 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. SQL 7: DTS Fixed-width Export?

2. dts adds extra space in fixed width export?

3. FIX - Fixed Width Export

4. fixed field export in dts skiping nulls

5. Export an Access table to a text (fixed width) file

6. Exporting to fixed-width text using DAO

7. Help! Exporting table to Fixed-Width Text file

8. Error 3027 in Access2K on attempting to export data to fixed width text

9. SQL Server 7 - fixed width column export

10. Fixed Width Export - truncation problem

11. Export to Fixed-Width Text File

12. Export fixed width?


 
Powered by phpBB® Forum Software