Access Excel Connection

[dkoucky]

I have an Access database with 34,061,507 rows of data. From that I need prob 30k of these rows, Excel home 365 does not allow PowerPivot. The data is a unique location ID I need to pull back 500 out of 100k of these and also the date I need about 60 days out of 365 (for most stations). Any suggestions?

 

[Derek Brown]

Depending on how easy it is to select the required records in Access, I would consider creating an Access Query and then "link" that Query to Excel as an Excel table. The linked data could then be refreshed whenever necessary.