Error importing excel into access

Question

1. running Windows 10.
2. running Office 2016 (excel and access) fresh install today (taking over 2 hours...)
3. created blank access 2016 local database (default file name Datatbase5.accdb)
4. Opened Access clicked External Data Tab > Excel Button > Select file name on hard drive ( .xlsx)
5. poof. nothing. 
6. ran system file checker to look for curruption (https://support.microsoft.com/en-us/kb/929833) no issues found
7. write post to help desk.

Answer 1

I built a brand-spanking-new machine about 6 months ago (new mb, memory, hard drives, cpu, etc). Installed Windows 10, updated, etc etc, and then installed Office 2013. Had all sorts of troubles the first time I opened Excel and Access, and finally (after about 4 hours of beating my head against the wall) concluded that my fresh install of Office 2013 wasn't so fresh anymore. I manually uninstalled and reinstalled and my troubles went away.

The moral of my story - don't assume your install is good simply because it's fresh. A 2 hour install time would indicate something is wrong, or that additional items were installed (which could also be corrupt).

Answer 2

As noted in the original post. I began with a 100% fresh install of office 2016. So that is not the problem.

Answer 3

Have you tried with a different Excel file?

Perhaps your installation of Office is invalid or corrupt (2 hours to install is an awfully long time). Try a Repair Install and see what happens, and also be sure your Windows install is up to date.

Answer 4

Scott, thanks for helping me get more precise:

4.a. the "Get External Data - Excel Spreadsheet" Dialog box appears

4.b. clicked the brows button, navigated to the xlsx workbook in question

  4.b.1. the first workbook i tried has multiple individual spreadsheets was hoping to automate the import of all.

  4.b.2. these second workbook i tried has one individual spreadsheet.

  4.b.3. the spreadsheet(s) on both workbooks have data

4.c. clicked radio button "import the source data into a new table in the current database"

4.d. clicked "OK"

5 (clarification of poof nothing happened) Yes that is correct i did not see the name of the new table appear under the Nav pane under Tables - i.e. poof nothing happened.

NOTE: reran the same thing today and still no result

Answer 5

Re 5, After you select the Excel file name, there are a number of choices. What did you choose? Is there data in the Excel file? Do you not see workbook name appear in the Nav pane under Tables?