I am trying to export some data on my worksheet into an Access table.
The two pieces of code below both work.
Public Sub ExportDataIntoAccessSlow()
Dim cn As ADODB.Connection, rs As ADODB.Recordset, r As Long
Const AccessStr As String = "Provider = Microsoft.ACE.OLEDB.12.0;Data...