Access Database: How to import the queried data from SQL database/table

Question

I have set up an Access database and now I am trying to import data into the Access database table from the SQL database. The Access database table is empty right now and I am trying to import the data from the SQL database with only a key value. For example, I only want to import the data that meets the following criteria.

Select * from myTable where UserID = 1234

I have set up the ODBC link to the table. I have been looking for ways to do this, but haven't found anything good.

Update

Figured it out and for anyone who might need to know how to do this, here are the steps.

 Create -> Query design -> Select the source table -> Select the desired columns -> Click "Append" -> Select the destination table -> Enter criteria -> click "Run"

Tim Lentine · Accepted Answer · 2020-01-13 20:30:15Z

2

Create an Access Append Query which uses the ODBC linked SQL Server table and writes the data to the Access Table. In the query, make sure you include your Where clause

answered Jan 13, 2020 at 20:30

Tim Lentine

7,9225 gold badges38 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Access Database: How to import the queried data from SQL database/table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related