D
Dan
Hello,
I am importing a tab delimited file into Excel over an existing Excel
worksheet. The issue is that I need only the fields defined in the
text file to be overwritten. I go to Data->Import External
Data->Import Data..., select my file, click next through the steps
(delimited, tab, general). Then on the following dialog I select
properties and select the "Overwrite existing cells with new data,
clear unused cells" radio.
What I really need is just "Overwrite existing cells with new data,
preserve unused cells" because what happens is if I have a line in the
text file that is just a carriage return, it clears everything in the
corresponding row in the worksheet. I need it to preserve the data on
that row.
In addition, if I have data defined in the text file for the first 3
columns of a row, I would like it to preserve the data in the
remaining columns of the row on the original worksheet.
Is there some way to do this with Excel 2002? (or 2000? or 2003?) Or
do I have to a write a script to do it. If I have to write a script,
can someone recommend a good starting point?
Thanks in advance for the help!
Dan
I am importing a tab delimited file into Excel over an existing Excel
worksheet. The issue is that I need only the fields defined in the
text file to be overwritten. I go to Data->Import External
Data->Import Data..., select my file, click next through the steps
(delimited, tab, general). Then on the following dialog I select
properties and select the "Overwrite existing cells with new data,
clear unused cells" radio.
What I really need is just "Overwrite existing cells with new data,
preserve unused cells" because what happens is if I have a line in the
text file that is just a carriage return, it clears everything in the
corresponding row in the worksheet. I need it to preserve the data on
that row.
In addition, if I have data defined in the text file for the first 3
columns of a row, I would like it to preserve the data in the
remaining columns of the row on the original worksheet.
Is there some way to do this with Excel 2002? (or 2000? or 2003?) Or
do I have to a write a script to do it. If I have to write a script,
can someone recommend a good starting point?
Thanks in advance for the help!
Dan