problem in importing text file!

[via135]

hi!

after importing a text file into excel and then saving it as a excel
workbook, the original text file also gets changed..! what should i do
to keep the original text file in tact?

any help pl?


-via135

 

[Guest]

Select DATA>IMPORT EXTERNAL DATA
Navagate to the text file
Open the text import wizard
Specify how the data will be imported Delimited or with comma Delimiter
Click finish Excel then displays the import Data dialog Box
Click Properties to display the External Data Range properties Box
In the Box remove the check mark from Save query Definition > click ok to
return to Import data Dialog, Specify the data location for the imported data
"Cell" location
Click Ok and Excel imports the Text File and you should be able to save with
no problems.

 

[via135]

i am using fixed width, not any delimiter..!

after finishing i didn't get any dialog box..!

can u pl explain a bit more?

-via135