I created a sql database from an existing Access database.
But instead of using it they will continue to use access and at time points they want to upload their data.
Not a merge or anything but delete all the data in the sql and then upload new data as its collected.
PLEASE don't ask me I am totally confused as to what or why.
I thought about just touching the tables (37) and then using ssis to to copy the data. There are 11 lookup tables that will not change over time (at least I don't think they will)
No they don't want to copy tables. Again Don't ask I am kept in the dark as to what they are doing or why.
Is there a simple way to automate this or make it quick to delete all existing data in these 37 tables and copy the access data.
I got an update on all this.
They are testing different data collection forms in access but I still don't know why they are copying the data to sql then later deleting the data a ...
Go to the complete details ...