Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1754
  • Last Modified:

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.
0
dibanezb
Asked:
dibanezb
3 Solutions
 
mastooCommented:
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
 
James MurrellProduct SpecialistCommented:
0
 
jmoss111Commented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now