Access 2003 front end - SQL Server 2000 back end.
I will soon receive 3 tables in Excel that I have to add to SQL Server.
These tables are related and will also have other tables related to them.
I will have to delete all rows from the existing 3 tables and then insert all information from excel.
My problem is I am not sure where to start with relationships. I will surely get an error if I delete all rows if relationships exist.
So what do I do. I am hopeing that from Access I can remove the relationship - delete - insert and add the relationships back.
Is this correct?
edit: This is not a one time event, this is going to happen at least every quarter so I am hoping to automate this for users to do so that I do not have to do it.
I will soon receive 3 tables in Excel that I have to add to SQL Server.
These tables are related and will also have other tables related to them.
I will have to delete all rows from the existing 3 tables and then insert all information from excel.
My problem is I am not sure where to start with relationships. I will surely get an error if I delete all rows if relationships exist.
So what do I do. I am hopeing that from Access I can remove the relationship - delete - insert and add the relationships back.
Is this correct?
edit: This is not a one time event, this is going to happen at least every quarter so I am hoping to automate this for users to do so that I do not have to do it.
Last edited: