VBA - Need Help To Store And Append the Data From Excel To Access

[ranjith2523]

Hi Friends,

I am using Microsoft Office 365.

I need your help to store and append the data from Excel to Access using Excel VBA. I have created an Excel File and Access file with the same headers and my requirement is that the data be moved to excel to access when I click a button. Once it is been pushed, If I add new data in excel and click the button then the data to be appended in Access. Simply I need to store the data in MS Access and I would like to use VBA code to do that.

I am not familiar with VBA Coding to work with the Access database but still, I spent a day to google and tried something like beginning with the below coding but I was not able to achieve it.

Dim dbCon As New ADODB.Connection
Dim dbCommand As New ADODB.Command

dbCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sdbpath & "; Jet OLEDB:Database Password=;"


Excel Sheet Name "Data"

Created Table In MS Access (File name - Access.accdb)

Can someone please help me with this?

Regards,
Ranjith

 

[Fluff]

Duplicate to: VBA - Need Help To Store And Append the Data From Excel To Access

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.