Create an access database by a VBA in Excel

[Blasphemer]

Hi,

I am looking to create an Access database from VBA in Excel. But I am unable to "create the database" and or open one if its already created. Here's the code I have so far. Any help?

Option Explicit

Public Sub sub_SendToAcces()

    Dim accApp As Access.Application
    Dim accDB As Object
    
    Set accApp = New Access.Application
    ' code to create a new database
    
    ' code to open it and set it in accDB variable

End Sub

 

[mr leno2020]

Ok thanks