How Do I Convert an Excel XLS to an Access MDB using Excel VBA

Answer 1

This task is straightforward if you're able to use VBA from within Microsoft Access; e.g.:

DoCmd.TransferSpreadsheet , , _
"tblImportFromExcel","C:\path\to\myfile.xls", True, "A1:B200"

TransferSpreadsheet documentation.