Best Way to Update Table in Access that changes daily

[Vaslo]

Hi all,

I have a large transaction table I pull down via CSV from our data warehouse everyday. Right now I have it as a linked table in Access. This is easy because all I do is overwrite the table by saving a new CSV out there.

There are a few disadvantages to this. First, I can't do any relationships that enforce referential integrity. I don't know when new data comes in and I should update my other lookup tables. Second, I have to create a query to work with this table and add calculated columns, though I have since been told I shouldn't be messing with this data anyway and should be adding lookup tables.

Is there a different way to do this? How would you approach something like this? Looking for the right way to do this. Thanks!

 

[ranman256]

you dont need to add columns to the table,...all this should be done in a query.
No work on your part.
save the data,
open the query.

 

[Vaslo]

you dont need to add columns to the table,...all this should be done in a query.
No work on your part.
save the data,
open the query.

Save the data how is my question? Again right now its a linked table to a CSV file. Everytime I overwrite the CSV file the database easily brings in the new data. That said, it comes with the issues I mentioned above.