My question is concerning “Recordsets”. Currently I am receiving some information in Excel and I would like to transfer that information into SQL database.
From my understanding I need to setup up a connection (currently using ADODB for my connection) . I am unaware of how to get the information from Excel into the” Recordset” (either by copying or other methods) and sending it to my SQL database. I’m fairly new to this, do you...