I am trying to copy data from a text file into a spreadsheet. However the data in the text file contains null characters (resultant of an FTP from a mainframe dataset), causing the readline to drop the entire text once the null characters start. Suggestions for any of the following would be appreciated-

1. Replace the nulls with spaces in VBA
2. Replace the nulls with spaces while FTP is done
3. Coax FileSystemObject readline to recognize data beyond the nulls.

or anything which you feel may help the cause.

Thanks,
Sam