Import Wizard

[AnytimeAnywhere]

My boss gets a file in his email that is a .txt file. When he opens the
file in Excel 2000, it doesn't bring up the import? wizard where you can
choose the delimiting options like fixed or comma. How can this be turned
on? Can it be turned on? We've changed the file type from .txt to .csv and
..dat but had no luck.

Thanks,

John

 

[Alfred Dearnley]

Hi John!

I'm assuming this is a data file not created and saved by Excel.

Have you tried Data>Get External Data>Import Text File?

Alf
| My boss gets a file in his email that is a .txt file. When he opens the
| file in Excel 2000, it doesn't bring up the import? wizard where you can
| choose the delimiting options like fixed or comma. How can this be turned
| on? Can it be turned on? We've changed the file type from .txt to .csv
and
| .dat but had no luck.
|
| Thanks,
|
| John
|
|

 

[AnytimeAnywhere]

Correct. This file came from a VAX.

No, I didn't try 'Get External Data.' I'll give that a try.

Thanks!

John

 

[Dave Peterson]

I don't think I've ever seen excel do this.

Just curious: What does the file look like when you open it in Notepad (or your
favorite text editor)?

 

[David McRitchie]

Hi John,
Opening a file in Excel with the .txt file extension should bring up
the Text Import Wizard. Opening with the .csv file extension
will *not* bring up the Text Import Wizard.

If everything is in one column you can select Column A and then
use Data, Text to Columns
to bring up the same dialogs as used in the Text Import Wizard.

If that does not work then you probably do not have spaces and
I would suggest first trying the TRIMALL macro at
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
and if that fails check to see what you really have instead of spaces
which is described there and a topic above.

 

[AnytimeAnywhere]

Thanks for the info!

I'll pass this onto my boss and see if it helps.

Thanks,

John