How can I insert 4000 rows of Excel data into a sql database
 

I have an Excel app that I want to place a button on that would allow the user to replace the contents of a sql database table with updated excel data on a sheet(b2:e4125). I can get it to clear the table and upload the data row by row but it bombs after 42 rows. How can I update the sql table all at once. Is there away to put the excel data in an ACCEPTABLE array for the values piece of the sql insert into command to work. Thankyou? skaty