troubleshooting Question

How to access a machine data source in SQL Server 2008

Avatar of DB-aha
DB-aha asked on
Microsoft AccessMicrosoft SQL ServerMicrosoft SQL Server 2008
6 Comments1 Solution466 ViewsLast Modified:
I am currently using access 2010 to get data from an external source. The steps I take to link to the external views provided to us are the following:

1. Click on the External Data Tab
2. Click on ODBC Database
3. Select Link to the data source by creating a linked table
4. Click ok
5. Click on the Machine Data Source  Tab in the pop up that appears
6. Select the data source I want to connect to
7. A list of views is presented to me to link to.

Now I would like to replicate this in SQL Server 2008 express edition as I believe I can do better with my queries in SQL server than being stuck in access 2010. Please provide the steps needed to be able to get to the same data source I am acessing in access but instead in SQL Server 2008. Thanks in advance.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros