Import wizard does not display

G

Guest

When I double click a file (File Type is File) that does not have an
association or extension of excel (.xls), it does not provide me the Text
Import Wizard dialog box. It automatically import the file but the data look
messy. The weird thing is when I start the excel program and open the file,
it provide me the Text Import Wizard dialog box. How would I make it so when
I double click the file it would provide me the Text Import Wizard dialog box
and not automatically import it.

Thank you
 
D

Dave Peterson

I'm not sure that you'll find an answer for this.

But after the file is brought into excel (as one column), you can select that
column and do Data|Text to columns.
 

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

Access Subscript out of range when importing into access 2010 from excel 0
Text Import Wizard 2
Import Data, using a command line switch 5
Forcing Text Import Wizard to run 6
Text Import Wizard 3
Unicode text and carriage returns 4
text file contains more data than will fit for a single worksheet 1
Text Import Wizard 1

Top