SQL and Access Table. Query

vbjohn

Registered User.
Local time
Today, 09:23
Joined
Mar 22, 2002
Messages
75
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?
 
Last edited:
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.
 

Users who are viewing this thread

Back
Top Bottom