Connecting to external data source - not allowing me to select multiple tables

Question

I have a web app that I built in Access.  I'm trying to create a pivot table in excel off of the data.  I can make a connection to the SQL database - no problem.  But in the process it doesn't allow me to select multiple tables (yes I've uncheck the select table box).  It only let's me select 1 table.  Which isn't very helpful.  Anyone have similar experience.  I can't get the connection wizard to give me the option of selecting multiple tables.  I've followed step by step instruction on every post out there. Driving me nuts!

Answer 1

Hi Andy,

I'd like to know if you get the Access data by these steps: click Insert > PivotTable > Use an external data source > Choose Connection > Select Table. If so, in the "Select Table" page, you can select the "Enable selection of multiple tables" and then tick several tables at one time.

If it's not your scenario, please let us know the following information so we can assist you further:

1. Your detailed steps to create pivot table, make connections to SQL database and select multiple tables.
2. The screenshot of "cannot select multiple tables"
3. The screenshot of your Office version. Open Excel > File > Account > the part under Product Information.

Regards,

Jared

Answer 2

Thanks Jared - When I hit "choose connection" it launches a connection wizard.  Then I put in all the connection attributes, and "test connection" works fine... But then the subsequent screens bring up a list of tables, but only allows me to select one table.  I have no option to select multiple. unselecting the checkbox doesn't enable me to select multiple

Answer 3

Hi Andy,

Since you are using Windows 10 as the category of this thread shows, I'd like to know which version of Office you are using, Office 2010 or others. If you download the Office apps from Office 365 portal, to help us understand the situation better, please provide a screenshot I mentioned above by taking these steps: Open Excel > File > Account > the part under Product Information. Below is an example:

Regards,

Jared

Answer 4

Version: 16.0.6965.2092

Answer 5

Hi Andy,

Thanks for your update.

I've installed the same version of Office in win10 as yours and also have the connection wizard,  but  somehow i cannot repro the symptom entirely. Therefore, appreciated it if you could share the detailed steps you create the custom web app, add tables in Access and your steps to configure the connection wizard after you clicking "choose connection". Some screenshots would be great. This could help me reproduce the issue and better troubleshoot it.

Thanks for your time and effort on this.

Regards,

Jared