Create a Read-Write ODBC Connection for SQL on Access

Question

Hi friends,

Have an SQL Server 12 DB on my machine with quite some data in different tables that I want to check and update swiftly enough. Unfortunately although found many solutions and AddIns for importing or linking all tables easily via DSN onto Excel spreadsheets or Access Database but found the same to be in read only mode not allowing real time editing. Using Office 2013. Plz see if any of you experts could help in creating some Read-Write connection allowing Real Time editing of the data on SQL either in Access or Excel via VBA or any other way in a simple step wise manner.

Thanks in advance!

Answer 1

Problem Resolved!

Thanx anyway!