insert a record into sql table using vba

[Hapr1]

Hi,
I have a supplier table in sql with an autonumber field ,supplier name and supplier ID field.. I need to get the supplier name and ID using Inputbox in excel. Then I need to send that data to the supplier table in sql server?
How do I do that?