I started a similar discussion here for full disclosure, but I think my question wasn't interpreted correctly and now I have a better way of asking (I think.)
https://www.accessforums.net/databas...ing-46934.html
Basically as I mentioned, I have a sales report I'd like to manage in Access. There are a number of linked tables, and I need to pull data every week to update it. As I mentioned as well, referential integrity holds me back from simply overwriting the table with the new data. The easiest thing to do would be just a quick import each week, which just can't be done .
My workaround is this: I have a table called "Weekly_Data" that feeds all my queries and reports. To update the data each week now, I think I will download the new data to another table - "Weekly_Data_Pull". I will run a delete query to clear the "Weekly_Data" table and then use an append query to just refill the data from the Weekly_Data_Pull. Not ideal, but not too bad. I have a feeling that there are better ways.
Any suggestions or problems you see here? I don't know much at all about SQL, so I don't know how that works or how to even implement it. I plan to learn it in the long run but need to get some results going this week.
As an aside - would love to do daily which would be my ultimate goal, but I'd need a fast process. Sometimes I'd have to update my other tables as well since Weekly data would have new cities, products, etc entering it - so it would be best to just update all of these each week (or each day!)
Thanks.