AnsweredAssumed Answered

Writing to access database

Question asked by Jay Donihoo on Mar 6, 2015
Latest reply on May 13, 2015 by Simon Turner

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=<filename>.mdb"

    .Open

End With

Outcomes