Hi,
I have data in a database (list of PC, servers, ...) where it is being up-to-date by the helpdesk people.
I have an Excel which has extra (financial) information on those assets which I can't put in the database.
I wan't to update the Excel list with the data from the database without losing the extra information that is already in the Excel.
I need to see that there are assets who aren't in the database anymore or are new in the databse but not yet in the Excel.
I can export the data in the database to Excel (there's no problem with accessing the data, but i have with merging it.
An (simplified) example of the Excel list is this
Server1 $3000 active
Server2 $3500 active
Server3 $3500 active
The data in the database is this
Server2
Server3
Server4
And I would have something like this
Server1 $3000 inactive
Server2 $3500 active
Server3 $3500 active
Server4 new
How can I do this?
thanks in advance
Patrick
Bookmarks