importing from Excel to Access (OfficeXP Pro)

[aap2]

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?

Thanks,

[WendellB]

Two issues here in my opinion. Importing prevents you from inadvertently modifing the spreadsheet and also lets you work with the data in multi-user mode (Excel is a single-user product). Also, I think you find performance is significantly better with Access tables if your tables contain large numbers of records.