Nicole,

I'm not aware of any way to do this using an OLE DB Provider.

You can Create ODBC connection to your SQL server and pump data into a SQL server table...