If the format and columns are same with the one you are working in. There should be no problems. If the data are well input, you can make some selection criteria in order to show the information you want. It can be done by using a list box or other objects. Hope it helps!
My biggest problem is I cant seem to wrap my head around using the unique" identifiers "
I have 3 sets of data - Quotes , Sales and back orders .
There is 5 of the SAME fields that I need to use to help with my visualization
Customer name , customer type , product code , product description and rep and this will always be there and also constantly change
If I generate this I get synthetic keys but my data loads properly ( I know that it is not great to have syn keys ) but it works .
The problem comes in when loading different days data - eg data was loaded from 1 June - 29 June and the app works great but as soon as I import my data for 30 June I get the load data error and none of my data gets updated
Will adding the master calendar make any difference ??