Trying to connect to an Access database, I copied some production code that works with the same .accdb file- why type it again, right?
'open connection
Set cn = CreateObject("ADODB.Connection")
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\TestData.accdb;"
'build recordset
sSQL =...