Access 2016, Excel 2016, Window 8
I'm having some trouble getting external data from an Excel file. I successfully transferred the Excel spreadsheet into my Access table the other day. But, wanted to make some changes to the data, so I made a copy of my Access db, eliminated a column in my Excel and tried to import/export again. I see 105 rows in my Excel file, but only 25 get transferred into my Access table. Tried it several times, but same result. Any idea what I'm doing wrong?