Downloading all fields in large access database table and linkin

1) how to download all the fields in an access database table (if going through Data/From Other Sources/From Microsoft Query/Choose Data Source/ and then selecting a database, the Wizard then opens to select the fields in tables but for large tables, it is not possible to select all the fields, especially when selecting multiple tables (exceeds the output). The way we have been selecting all of the fields in one table (but not able to connect multiple tables) is through Insert/Pivot Table/External Data Source and browsing to connect to a new source. The Data Connection Wizard is then used for an ODBC data source and a whole table is selected (all fields download even if it is a large table).