Insert records into an sql database with vba macro from excel range
I have a excel spreadsheet that needs to be regularly imported in an sql database.
I would like the user to be able to run a personal macro to update this data into the database then I have some other macros to run.
I can loop through each on the lines and inset the records one by one but this takes quite a while - I would like to be able to insert a range from the spreadsheet into a table in an SQL database in one process. Is this possible.