Hello, I believe that's question for some experienced users. I'm looking for the fastest way of sending data from Excel sheet to Access database. The shape of sheet looks like this:
Currently I'm using code:
Dim acc As New Access.Application acc.OpenCurrentDatabase Filepath, , sPassword acc.DoCmd.TransferSpreadsheet _ acImport, _ acSpreadsheetTypeExcel12Xml, _ "Statistics", _ Excel.ActiveWorkbook.FullName, _ True, _ "Mistakes$A1:B" & iLastRowMistakes acc.CloseCurrentDatabase acc.Quit Set acc = Nothing
I know that I can also use SQL mixed with VBA.
Would it be faster? Would I feel the difference? Is there any other way to do this (fastest possible of course)?