I am using Access 2007. I have created an ODBC connection. Using the External Data tab I can manually select my ODBC connection and link to a Table in an external database. Currently the table that I'm interested has massive amount of data and I would like to use filtering criteria using SQL to limit the data before importing to access 2007.
Is it possible to do the same in VBA so that I can AUTOMATICALLY open the ODBC connection and AUTOMATICALLY limit the data using SQL query before downloading to Access 2007 database? If you can help with the code and briefly explain what the code does/how it works, that would be very helpful! Thanks. TSL