Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
Providing you need to add data from an Access database to an existing Excel solution and pull it in to a PivotTable, how would you start the process?
Go to the Data tab > Existing Connections > Select your database > Select the table or query you’d like to use
Go to the Data tab > From Access > Browse to your database > Select the table or query you’d like to use
Open the Access database and export the table or query into an Excel file.
When connecting to a database, we have the option to “land” our data in either a table or directly into a PivotTable. What reason would you want to land your data into a table first?
It must be landed to a table in order to refresh the data since you have to right click the source data table to refresh it.
Your data set is less than 1,048,575 rows.
You can see the data first, and create new columns using formulas.
When connecting to a database, we have the option to “land” our data in either a table or directly into a PivotTable. What would force you to avoid landing your data in a table first?
All the fields you could ever need are pre-calculated in the database already, so no manipulation will ever be needed in the worksheet.
Your data set is greater than 1,048,575 rows.
The IT department has implemented a limit on your file size, forcing you to keep it under 5 MB.