Hey guys,

really new to VBA. Trying to write a statement as described in the title.

For more description:
mySQL database is called materialsdb
materialsdb holds 3 tables: materials, manufacturers, vendors
column within materials table is called part_ID

excel worksheet is called BOM (Bill of materials)
column within BOM is also called part_ID


Haven't got a great grasp on syntax yet but I'm hoping to write something like:
If materialsdb.materials.part_ID (mySQL) matches BOM.part_ID (excel), then
fill in BOM columns with matching data from materialsdb tables