SQL and Access Table. Query

[vbjohn]

SQL Database - Insert - Access Database???

How can you run a query to grab data in a SQL database and then insert it into a Access Table?

 

[Pat Hartman]

Link to the SQL table. Create a select query that selects the data you want from the SQL table. Change the query type to "Append". Choose the Access table as the append to table. If all of the column names don't populate, you may need to manually match columns from the SQL table to the Access table if the names are not identical.