Is it possible to save excel userform data into Access

[manissinha]

Hi

I have created a user form in excel vba for multi user is is possible to save its data into Access.

thanks
Manish

 

[stumac]

It is possible, something like this:

    Dim cn As New ADODB.Connection
    Dim cs As String
    Dim rs1 As New ADODB.Recordset
    cs = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=[COLOR=#ff0000]C:\MyDatabase.accdb[/COLOR]"
    cn.Open cs
    rs1.Open "[COLOR=#FF0000]MyTable[/COLOR]", cn, adOpenDynamic, adLockOptimistic
        
    With rs1
        .AddNew
        .Fields("[COLOR=#FF0000]myField1[/COLOR]") = Me.[COLOR=#FF0000]MyTextBox1[/COLOR]
        .Fields("[COLOR=#FF0000]MyField2[/COLOR]") = Me.[COLOR=#FF0000]MyTextBox2[/COLOR]
        .Update
    End With
  
  
Set rs1 = Nothing
cn.Close
Set cn = Nothing

The red part will need to be changed to meet your needs. Also in this example I have a table as the recordset - you can also use SQL for this.