VBA to push data from an Excel Table to SQL table

[gheyman]

I have data in Excel tables that I need to push to an identical SQL table using VBA. I don't have SSMS. I need to use VBA.

I have the ability, using excel Power Query to pull the data but I also need to push back the data. Any suggestions? Again, I don't have SSMS nor can I download other types of software. IT stated I need to use VBA. I have write access to the tables.