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

Select DATAIMPORT 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.
--
William<"M"




"via135" wrote:

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

Specify how the data will be imported Delimited or with comma Delimiter

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

Click finish Excel then displays the import Data dialog Box

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

can u pl explain a bit more?

-via135



On May 3, 10:26 am, Sunday88310
wrote:
Select DATAIMPORT 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.
--
William<"M"



"via135" wrote:
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- Hide quoted text -

- Show quoted text -