How to Save Filtered Data to Another Table in Access

Written by jaime avelar

Share

Tweet

Share

Pin

Email

Save query data from one table to another using VBA. (Binary code high-tech abstract texture series image by artcalin from Fotolia.com)

Knowing how to save information from one table to another table can save you time when transferring data in a database. Microsoft Office Access is a relational database management system included in the Microsoft Office suite. Visual Basic for Applications (VBA) is a computer programming language developed by Microsoft. VBA can be used in Access to automate processes otherwise performed manually. In a few steps you can write VBA code to query data from one table and save it in another table.