hi there...

but you are working with access, that doesn't have Store Procedures.. so your only way to do this is passing the rows one by one..

maybe you are not using the right database for this?? How much data are you inserting?? did you know that access database has a cap at 2 GB? (1 GB is you are using access 95)...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========