Importing data from text file without overwriting certain cells

[Sean Murphy]

I have a VBScript that writes Active Directory computer infromation to
a text file. Excel imports the data from this text file and I build
charts reflecting the status of these machines.

I'm trying to monitor the progress of a migration from one domain to
another.

The script output indicates the computer is either in the source
domain, target domain, or unknown (because it is either offline or
access is denied).

My concern is, if I run the script a second time and a computer that
may have reported it was in the target domain (successful) the first
time may be offline and therefor no longer be successful. (Because the
cell will now change to unknown.)

I would like to import any new and/or updated data and NOT update a
cell that already has a value = the target domain (successful).

Does this make sense?

Thanks in advance for your attention.

Regards,
Sean Murphy

 

[Paris]

excel can read the file but it isn't database to store values...

i think you should try to build a database like access
read your text file and with access update query put new values to an
access table


Sean Murphy :