This is the last step of a project on which I am working, I have a form that contains data in a table / Writes edit data, Access, I am trying to write a macro which saves data and then exports to the SQL server in the table. I have already established a connection between Access and SQL, I am not just good in the coding section. Any insights will be greatly appreciated.
Its easiest way is to create an append query that is only saved in the linked table in the local table (Local In the table) Record your form. Then use a macro to insert an event on your form to run the append query.
Comments
Post a Comment