I finally semi-solved this and hope it will help someone else.
I use DoCmd.TransferSpreadsheet to import a file into an Access table from Excel, and it was working fine until several weeks ago. All my parameters were working perfectly, and then all of a sudden, when it would tell me how many records it was going to import, it was a ridiculously large number. I finally figured out that if I put in the sheet name as well as a data range, it worked perfectly (e.g., Sheet1!A1:G119).
Before, I just gave the file name without that parameter. The only thing I changed (and this must somehow be the cause) was to get rid of every time I opened an excel spreadsheet, a popup could come up stating: Personal.XLSB is Locked for Editing Open Read-Only or click Notify... -- the only way I could find to get rid of it was to go to View in File Explorer and change view to Detail Only with no preview pane.
I would like to find a way to not have to explicitly state the sheet name and range as this will vary with every import.
Any help would be appreciated.