question

RobertCabeca-2105 avatar image
0 Votes"
RobertCabeca-2105 asked erinding-msft commented

Power Pivot not importing Acess DB in Excel 2016. Error message is blank

Greetings,

I am using excel 2016 MS Pro Plus version.

When I attempt to import an DB of any size into power pivot, the import fails. When I click on the link for the error message, the error is blank with no information.

I CAN import the same DB's into excel one table at a time, but not multiple tables.

Any feedback is greatly appreciated.

Kind regards,
Robert

power-query-not-supportedoffice-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

erinding-msft avatar image
0 Votes"
erinding-msft answered erinding-msft commented

anonymous userCabeca-2105

I do the test on my Office Professional Plus 2016 (version 16.0.4266.1001) and import multiple tables in the same DB into excel at a time successfully.
Could you please tell me how you imported Access DB?
Did you follow the below steps?
If no, please operate as below.

  • Click Manage in Power Pivot tab.

52356-1.png

  • Choose From Access from the drop-down menu of From Database.

52441-2.png

  • Click Browse and select the Database that you want to import, then click Next.

52442-3.png

52443-4.png

  • Choose how to import the data, then click Next.

52350-5.png

  • Select multiple tables that you want to import, then click Finish.

52451-6.png

Then you will see the import operation succeeded.
52424-7.png

If you operated like above, in which step did you get the error?

Any updates, please let me know.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


1.png (15.1 KiB)
2.png (17.6 KiB)
3.png (16.0 KiB)
4.png (17.5 KiB)
5.png (14.9 KiB)
6.png (17.7 KiB)
7.png (19.1 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

anonymous userCabeca-2105

How is your issue going?

0 Votes 0 ·