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
.Provider = "Microsoft.ACE.OLEDB.12.0"
.Mode = adModeReadWrite
.ConnectionString = "Data Source=<filename>.mdb"