How to create a connection for SQL database

[Meh]

I want to find a part number in a sql table and if it is there, I want to
display quanity on hand.

I wan to do it in VBA.

I would appreciate if someone please show me how create connection etc.

Thanks