-
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?
-
They both end up giving you the same result (adding a new record), but if you prefer speed over portability (which it sounds like you would, seeing you would only need a single SP), use a stored procedure