I am trying to clear the contents of a table in Access from Excel, using VBA.
This code works:
Option Explicit
Sub DeleteDataUsingActiveX()
Dim MoviesConn As ADODB.Connection
Set MoviesConn = New ADODB.Connection
Dim MoviesCmd As ADODB.Command
Set MoviesCmd = New...