Access db synced to MSSQL db

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. Thanks