I want to input values into a database from
an Excel spreadsheet containing over 10000 rows. Is it inefficient to call a stored procedure for entering each row from the sheet (my guess would be that it is)? Is there
a way to pass all the rows as a parameter to the stored procedure or am I simply better off just establishing a connection to the DB and directly adding the values using ADO?