Database Implentation Question
Hello everyone, just nee a little input.
My supplier("A") has provided me with there catalog in a excel spread sheet with item#, desc....etc..
So my question is would i import all that information in to my current product table which is
in my One database or...
would I create another Database just for this catalog(which will be updated year to year) and ref it as an external source?
Also if I have supplier "B" send me there catalog would I combine the 2 together or keep it separate?
Any suggestions would be helpful...maybe you faced something similar to this.