I need to modify a sql file which will be used to add records to a mssql db from an access db file. I need also to set this up so that it adds new records to the mssql db once a day on a schedule. The sql has already been written to update to a mssql db but needs to be tweaked to work with access. Should not take long if you have skills in mssql and access.
I found a program that will bring the access data into a new mssql table within the db I need to add records to. So all I need now is a scheduled procedure to populate three other mssql tables from the one imported table containing the data from access all within the same db.