Question

Locked

DATABASE UPDATE

By fernando.palma ·
Untill now no one has ever been able to provide me with a solution for this situation:

I work with excel tables. everyday I receive tables from several sources. those tables contain data only. each table from each source contains similar data fields and some different.

I have created a main table where I gather all the information from those sources, adding other fields on the table to identify each line in order to know from which source it came from and a field to add a image source.

Needing to update the main table constantly, everytime I need I have to erase content from it and cut and paste again all the information from the source tables (no problem with this) but need to go all the field line add the image file source again.

I have presented this to some programmers and untill now no one has ever been able to provide me with a solution to update my database.

What I need is:

HAving created the main table and adding the field lines once with source name and image file source (image.jpg) each time I receive other source tables from the same source, pasting it, the programm could identify: what's new in the new source file; what exists in the new source file and in the database but that has been changed, what does not come on the new source file but is on the database. After detecting what is different creates alerts only for the files that era NEW, CHANGED, and DISCONTINUED.

Does anyone can help? Is ther a program that helps me do this?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums