title: Office VBA ODBC to SQL Server
body: <p>I have to connect a Word Document to a SQL Server with VBA in order to read and write records. Now, I'M really confused as of the many different ways to connect to a database. There's ADO, ODBC and so on. I've seen very different ways of connecting a SQL Server database.
  A co-worker wants me to use ODBC.</p>
  
  <p>So: <strong>What is the best way to connect to a SQL Server database using ODBC in Office VBA?</strong></p>
  
  <p>An example for a SELECT and INSERT statement would also be appreciated.</p>
  
  <p>Edit: Isn't there something like "System.Data.SqlClient.SqlConnection" and "System.Data.SqlClient.SqlCommand" in VB .Net/C#?</p>