Use the open method of a recordset (Select SQL Statement) and dump the resulting recordset into a delimited ascii file?

I need ultimate speed. At work I am pulling data from a live datasource (Many, many pulls) and taking the results and inserting them into tables on a sql server. The problem is twofold:

1) the process runs overnight and it takes too long.

2) I can't seem to figure out how to design the app using asynchronous processing using either the ado paramaters in the connection and recordset objects or by using an activeX exe code component. I don't know if using these methods would speed up the process but I need better results than I am getting doing one at a time which is what I am doing now.

Any help or links to some examples would be greatly appreciated...