Text File Import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When opening a text file in Excel, the Text Import Wizard
doesn't show and the file opens as blank with nothing in
it. Any ideas?

Thanks,
- Andrew.
 
When opening a text file in Excel, the Text Import Wizard
doesn't show
Click to expand...

Typically this is because the file extension is one that Excel "knows"
and it "helps" you by automatically opening it. To force the wizard to
appear, change the text file's extension to something that Excel
doesn't recognise, like .cma.
and the file opens as blank with nothing in
it. Any ideas?
Click to expand...

Even if the wizard is bypassed, you'll typically only see this if
there's really nothing in the file. First check the file size; is it
large enough to suggest the presence of real data? Second, open the
file in Notepad or WordPad to see whether there's anything in there
aside from maybe spaces, tabs or other padding characters.
 
You must log in or register to reply here.

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

Open Text Files in Excel, Changed Behavior 4
Unicode text and carriage returns 4
Importing text files automaticly. 5
Importing Text Files Into Access 1
Import Data, using a command line switch 5
Text Import Wizard 2
text file contains more data than will fit for a single worksheet 1
Which is the best MBOX Converter Tool different formats conversion? 4

Back
Top