Share via

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

Anonymous
2016-10-12T01:15:11+00:00

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!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-10-19T16:02:50+00:00

    Hi Andy,

    Any update would be appreciated. If you need further assistance, please let us know.

    Regards,

    Jared

    0 comments