Link SQL Server data to MS Access database with filters
<p>I would like to create a link from an SQL Server database to an MS Access database for reporting purposes. I don't need all the data from the table just the past few years worth. Is there a way through Access VBA or MS Access tools to only bring in the rows I need rather then all rows?</p>