title: Move data from SQL Server to MS Access mdb
body: <p>I need to transfer certain information out of our SQL Server database into an MS Access database.  I've already got the access table structure setup.  I'm looking for a pure sql solution; something I could run straight from ssms and not have to code anything in c# or vb.</p>
  
  <p>I know this is possible if I were to setup an odbc datasource first.  I'm wondering if this is possible to do without the odbc datasource?</p>