[Webinar] Streamline your web hosting managementRegister Today

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

Export data from SQL to Access

Hi,

I am a newbie to SQL and Access. I wish to ask on how to Use Data Transformation Services (DTS) to Export Data from a SQL Server Database to a Microsoft Access Database?

Thank you in advance..
0
yanmay
Asked:
yanmay
1 Solution
 
yanmayAuthor Commented:
please reply..
0
 
duobaCommented:
use the dts wizard in sql server.

you will find export data if you right click on the Data Transformation Services in the Enterprise Manager tree.

Then it just as simple as following the wizard through.  It will ask you what table/query you want to export, next it will ask you what to export to.  At this stage you choose microsoft access...
0
 
nigelrivettCommented:
Why do you want to use dts?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
shijeeCommented:
Try the other way out.

import into access from sql server.

in access, file -> get external data ->import

There choose from files of type ODBC databases

you should have created a DSN to the sql server.

use the DSN, suplly password & just import whatever u want.

0
 
duobaCommented:
I generally use dts for exports that I want to happen on a regular basis, i.e. save teh dts package.

0
 
duobaCommented:
you can then schedule that package to run periodicaaly.  It also allow you to aplly transformations to the data eaily at the time of import/export, unlike microsoft access import/export. It also lets you design packages that has more of a process. For people you dont have a good understanding of t-sql, and even those with, its a very useful tool for managing importing and exporting information.
0
 
walterecookCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: duoba {http:#8100579}

Please leave any comments here within the next four days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

walterecook
EE Cleanup Volunteer
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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