Hi,
I am fairly new to access and have been asked by my boss to move our current stock portfolio ranking system from excel to access so that we can conduct analysis over time of our changing views on each stock.
The data in the tables that I create will be updated on a regular basis via an export from excel. The included data will be a list of all the stock codes, current stock price, our valuation, a qualitiative quality score and our ownership of each stock.
How do I set the table up so that each time I export new updated data into the access table for each stock the old data is not deleted. The aim being that we can look at one particular stock and see how our valuation of the stock has changed over time OR our quality score for the stock has changed over time.
Thanks for your assistance in advance.
I am fairly new to access and have been asked by my boss to move our current stock portfolio ranking system from excel to access so that we can conduct analysis over time of our changing views on each stock.
The data in the tables that I create will be updated on a regular basis via an export from excel. The included data will be a list of all the stock codes, current stock price, our valuation, a qualitiative quality score and our ownership of each stock.
How do I set the table up so that each time I export new updated data into the access table for each stock the old data is not deleted. The aim being that we can look at one particular stock and see how our valuation of the stock has changed over time OR our quality score for the stock has changed over time.
Thanks for your assistance in advance.