<

Creating and Executing a SQL Pass-thru Query

Posted on
12,257 Points
4,257 Views
10 Endorsements
Last Modified:
Published
Experience Level: Beginner
5:15
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pass-thru query. This video covers the basics of creating and working with pass-thru queries.

Video Steps

1. The video first shows the viewer how to create a pass-thru query in Access.

2. The data in the SQL Server table that the pass-thru query will return is displayed in SQL Server Management Studio.

3. We then create the T-SQL string in the pass-thru query and create an ODBC data source that will be used to connect to the SQL Server.

4. Finally, we store the ODBC connection string in the pass-thru query so that the pass-thru query can be run at any time.

10
Author:TechMommy
0 Comments

Suggested Videos

Title Views Activity
Shuffle - 4 - Append Query 32
Query data with no SQL code (5) 20
Query data with no SQL code (7) 24
Query data with no SQL code (8) 21
I am not a database expert nor am I conversant with database design, but I have had a couple of run-ins with databases that are either badly designed or use a platform that doesn’t meet the needs of the end-user.  I would like to think this is a "le…
A while back I wrote an article about the Power Query Editor and PowerBI (https://www.experts-exchange.com/articles/37938/PowerBI-and-the-Query-Editor-Save-time.html).  I have realized that my coworkers primarily use Excel and So have changed the ar…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month