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.

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?