When opening a text file in Excel, the Text Import Wizard
doesn't show
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?
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.
