software

I have imported a text file into an excel sheet.
Now I want to import more data to the same sheet, without changing the
existing data.

I have done this many times in the past, but now I only have the option of
editing existing text file.

Have I changed a setting somehow?

How can I get back to being able to import multiple text data files into a
sheet?

Thanks
Scottquot;smokey99quot; gt; wrote in message
...
gt;I have imported a text file into an excel sheet.
gt; Now I want to import more data to the same sheet, without changing the
gt; existing data.
gt;
gt; I have done this many times in the past, but now I only have the option of
gt; editing existing text file.
gt;
gt; Have I changed a setting somehow?
gt;
gt; How can I get back to being able to import multiple text data files into a
gt; sheet?
gt;
gt; Thanks
gt; Scott
gt;

I'm using Excel 2000, and I've never seen the ability to open a text file
into an existing sheet. The newly opened text file must be cut amp; pasted into
an existing sheet. What exact steps (menu clicks) do you recall taking in
the past, in order to quot;import more data to the same sheetquot;?
HI Doug,
I am using 2003
Normally, with a sheet open, I select gt; Datagt;Import external datagt;import
datagt; then drill to the txt file, I want.

Now, the import data is not highlighted and unavailable, only the quot;edit text
importquot; amp; quot;data range propertiesquot; are available

Thanks
Scottquot;Doug Kanterquot; wrote:

gt; quot;smokey99quot; gt; wrote in message
gt; ...
gt; gt;I have imported a text file into an excel sheet.
gt; gt; Now I want to import more data to the same sheet, without changing the
gt; gt; existing data.
gt; gt;
gt; gt; I have done this many times in the past, but now I only have the option of
gt; gt; editing existing text file.
gt; gt;
gt; gt; Have I changed a setting somehow?
gt; gt;
gt; gt; How can I get back to being able to import multiple text data files into a
gt; gt; sheet?
gt; gt;
gt; gt; Thanks
gt; gt; Scott
gt; gt;
gt;
gt; I'm using Excel 2000, and I've never seen the ability to open a text file
gt; into an existing sheet. The newly opened text file must be cut amp; pasted into
gt; an existing sheet. What exact steps (menu clicks) do you recall taking in
gt; the past, in order to quot;import more data to the same sheetquot;?
gt;
gt;
gt;

OK, I just figured out this only happens when the original text file is
stored in the quot;My data sourcesquot; folder.
Text files imported from other folders don't seem to have this problem.
Thanks
Scott

quot;Doug Kanterquot; wrote:

gt; quot;smokey99quot; gt; wrote in message
gt; ...
gt; gt;I have imported a text file into an excel sheet.
gt; gt; Now I want to import more data to the same sheet, without changing the
gt; gt; existing data.
gt; gt;
gt; gt; I have done this many times in the past, but now I only have the option of
gt; gt; editing existing text file.
gt; gt;
gt; gt; Have I changed a setting somehow?
gt; gt;
gt; gt; How can I get back to being able to import multiple text data files into a
gt; gt; sheet?
gt; gt;
gt; gt; Thanks
gt; gt; Scott
gt; gt;
gt;
gt; I'm using Excel 2000, and I've never seen the ability to open a text file
gt; into an existing sheet. The newly opened text file must be cut amp; pasted into
gt; an existing sheet. What exact steps (menu clicks) do you recall taking in
gt; the past, in order to quot;import more data to the same sheetquot;?
gt;
gt;
gt;

Good! I was about to write back and say that I'm mystified, since my version
isn't exactly like yours.

quot;smokey99quot; gt; wrote in message
...
gt; OK, I just figured out this only happens when the original text file is
gt; stored in the quot;My data sourcesquot; folder.
gt; Text files imported from other folders don't seem to have this problem.
gt; Thanks
gt; Scott
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt; quot;smokey99quot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have imported a text file into an excel sheet.
gt;gt; gt; Now I want to import more data to the same sheet, without changing the
gt;gt; gt; existing data.
gt;gt; gt;
gt;gt; gt; I have done this many times in the past, but now I only have the option
gt;gt; gt; of
gt;gt; gt; editing existing text file.
gt;gt; gt;
gt;gt; gt; Have I changed a setting somehow?
gt;gt; gt;
gt;gt; gt; How can I get back to being able to import multiple text data files
gt;gt; gt; into a
gt;gt; gt; sheet?
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt; Scott
gt;gt; gt;
gt;gt;
gt;gt; I'm using Excel 2000, and I've never seen the ability to open a text file
gt;gt; into an existing sheet. The newly opened text file must be cut amp; pasted
gt;gt; into
gt;gt; an existing sheet. What exact steps (menu clicks) do you recall taking in
gt;gt; the past, in order to quot;import more data to the same sheetquot;?
gt;gt;
gt;gt;
gt;gt;
Well now you know :-)

Thanks for the effort Doug, have a good one
Scott

quot;Doug Kanterquot; wrote:

gt; Good! I was about to write back and say that I'm mystified, since my version
gt; isn't exactly like yours.
gt;
gt; quot;smokey99quot; gt; wrote in message
gt; ...
gt; gt; OK, I just figured out this only happens when the original text file is
gt; gt; stored in the quot;My data sourcesquot; folder.
gt; gt; Text files imported from other folders don't seem to have this problem.
gt; gt; Thanks
gt; gt; Scott
gt; gt;
gt; gt; quot;Doug Kanterquot; wrote:
gt; gt;
gt; gt;gt; quot;smokey99quot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I have imported a text file into an excel sheet.
gt; gt;gt; gt; Now I want to import more data to the same sheet, without changing the
gt; gt;gt; gt; existing data.
gt; gt;gt; gt;
gt; gt;gt; gt; I have done this many times in the past, but now I only have the option
gt; gt;gt; gt; of
gt; gt;gt; gt; editing existing text file.
gt; gt;gt; gt;
gt; gt;gt; gt; Have I changed a setting somehow?
gt; gt;gt; gt;
gt; gt;gt; gt; How can I get back to being able to import multiple text data files
gt; gt;gt; gt; into a
gt; gt;gt; gt; sheet?
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks
gt; gt;gt; gt; Scott
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt; I'm using Excel 2000, and I've never seen the ability to open a text file
gt; gt;gt; into an existing sheet. The newly opened text file must be cut amp; pasted
gt; gt;gt; into
gt; gt;gt; an existing sheet. What exact steps (menu clicks) do you recall taking in
gt; gt;gt; the past, in order to quot;import more data to the same sheetquot;?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Dang, thought it was fixed, but same problem again.

May reboot the PC and see whats up.quot;smokey99quot; wrote:

gt; I have imported a text file into an excel sheet.
gt; Now I want to import more data to the same sheet, without changing the
gt; existing data.
gt;
gt; I have done this many times in the past, but now I only have the option of
gt; editing existing text file.
gt;
gt; Have I changed a setting somehow?
gt;
gt; How can I get back to being able to import multiple text data files into a
gt; sheet?
gt;
gt; Thanks
gt; Scott
gt;

quot;smokey99quot; gt; wrote in message
...
gt; Dang, thought it was fixed, but same problem again.
gt;
gt; May reboot the PC and see whats up.

There's only one remaining explanation: Satan.

:-)

I ran into this same problem yesterday and too was baffled. I finally
found that if I unchecked the quot;Save query definitionquot; option in the
External Data Range Properties box (accessed by clicking on the
Properties button in the Import Data box you see after clicking on the
Finish button in the Import External Data wizard), I could import data
from another text file (the import data option wasn't grayed out
anymore). Hope this helps.--
kathynewman
------------------------------------------------------------------------
kathynewman's Profile: www.excelforum.com/member.php...oamp;userid=33878
View this thread: www.excelforum.com/showthread...hreadid=519875