Importing Ascii file to Excell won't include Null Characters

K

KJM

I have an ASCII text file (inlcues extended Ascii) that I am trying to import
into Execl (Office 2003). When I use the Import Wizard, the NULL fields
between valid data are omitted. So a file that should have 511 characters
imports with only 90 characters. (the rest were randomly spaced Null
characters)

I there another way to do this?

I need this as an automated process. but I did test the ASCII file
contents by using copy and paste. I then get nearly all the data ( I get 510
characters instead of all 511 ) I'm not sure why I am missing one character
(9) the middile of the string? But that may not be related to the NULL issues.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Querying for Extended ASCII Characters 1
Illegal Character Imported 7
Excel2007 - More columns when importing ascii file? 2
Excel to ASCII Fixed Format 2
Odd character display (ASCII 128-159) 1
Import File Line by Line 1
Access 2007 importing data with extended character sets. 5
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0

Top