Hello All,

     I am currently exploring options on how to write values from Solidworks directly to an Access DB. I have zero knowledge of Access or how to communicate with it. Any help or direction would be greatly appreciated. Below is the code I found for connecting with Access but writing to it is beyond me.

Dim conn As ADODB.Connection

  Set conn = New ADODB.Connection

With conn

    .Provider = "Microsoft.ACE.OLEDB.12.0"

    .Mode = adModeReadWrite

    .ConnectionString = "Data Source=.mdb"

    .Open

End With