CODEWITHSUNDEEP
sql-serverms-access
user2119980
user2119980

Reputation: 509

Writing A Macro in Access to save and export to SQL Server

This is the final leg of a project I am working on, I have a form which writes/edits data to a table in access, I am trying to write a macro on the form that saves the data and then exports to the table in sql server. I have already established the connection between access and sql, I am just not good at the coding part. Any insight would be greatly appreciated.

Upvotes: 0

Views: 806

Answers (2)

Dave Bennett
Dave Bennett

Reputation: 868

The easiest way to to this is to create an append query that will append the record your form just saved (to the local table) from the local table to the linked server table. Then use a macro tied to the After Insert event on your form to run the append query.

Upvotes: 1

TT.
TT.

Reputation: 16146

You could set up a linked table, linked to the SQL Server table, and do your export from Access as you would to your Access table.

Upvotes: 0

Related Questions