Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Access to SQL using DTS for data transfer		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

numptyy
Starting Member

1 Posts
Posted - 07 September 2004 :  14:36:43  Show Profile
I've read the posts about converting from Access to MS SQL Server. They all say we should use DTS to transfer the data from the Access database to the SQL Server database.

Nobody says what DTS actually is and where you get it from. How do I perform this transfer?

Podge
Support Moderator

Ireland
3776 Posts
Posted - 07 September 2004 :  16:34:33  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
In Enterprise Manager right click the database you want to import the Access Database into.
Select All Tasks > Import

A wizard should guide you from there.
Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07