How to export data from SQL Server 2005 to Access using a queries.

Posted on 2008-10-06
Medium Priority
Last Modified: 2013-11-30
I need to export some tables from my SQL Server 2005 to Access using queries in order to filter data that I want to export. I can use Visual Basic if it is necesary.
Question by:dibanezb
LVL 21

Assisted Solution

mastoo earned 300 total points
ID: 22656017
In the Access database, you could create linked tables to the sql tables.  Then you can use access queries to filter the data from those linked tables and insert into the regular access tables.
LVL 30

Expert Comment

ID: 22656200
You can 'pull' the data into access using the method descrbied above, or you can 'push' the data into MS Access using linked tables or SSIS in SQL Server.
LVL 31

Accepted Solution

James Murrell earned 900 total points
ID: 22657114
LVL 18

Assisted Solution

jmoss111 earned 300 total points
ID: 22658120
Hi dibanezb,

Or you could use pass through queries which would result in better performance than linked tables  in Access by bypassing the Jet query parser and is very easy to set up.



Author Comment

ID: 22666134
Thanks for your help.

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question