I found some help on this by doing a search before sending in this question. It seems pretty straightforward, however, I'm getting an error message when I attempt to execute. Here is the docmd line that I have in the 'On Click' event of a command button on a form:
Private Sub cmdImportPCS_Click()
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "PCS_Import", "N:\cs\mis\Metrics Database\Commission Services Database.xls", True, "A:F"
Here is the error message: 'Run-time error 3275': Unexpected error from external database driver (24). I also found something on this that nico posted, but the link is no longer working.
Can an expert help me resolve this? Thanks!