I have around 500 records to insert into a table in Access 2000. I am using ADO. Is it possible to pass all of the 500 records to a query using some kind of SafeArray parameters and Insert them all at once? Any tips how this can be accomplished ? Thanks