Bulk Insert from SQL server to Access

From: aparna (adesai_at_spryance.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 14:40:22 +0530

Dear all,
In my program I am fetching a record form SQL server and Inserting into
Access
I am doing this using do while Loop.
 can I insert all the records in Access at a time?
pls reply urgently