I have to import data from an Excel workbook into Access. The data is in 12 worksheets and I put the data into 12 corresponding tables. I use
DoCmd.TransferSpreadsheet acImport, .....
for each of these worksheets.
Here is the opinion question of the day. Is there any advantage to doing the TransferSpreadsheet method above over
using ADO to create a link with the ActiveConnection property in Recordset objects?