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

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.
dibanezbAsked:
Who is Participating?
 
James MurrellConnect With a Mentor Product SpecialistCommented:
0
 
mastooConnect With a Mentor Commented:
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.
0
 
nmcdermaidCommented:
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.
0
 
jmoss111Connect With a Mentor Commented:
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.

http://www.aspfree.com/c/a/Microsoft-Access/On-Using-Passthrough-Queries-in-MS-Access/

Jim
0
 
dibanezbAuthor Commented:
Thanks for your help.
0
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.

All Courses

From novice to tech pro — start learning today.