Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
matthisco
Starting Member
48 Posts |
 Posted - 2009-02-03 : 04:21:14
|
| Can anyone tell me the best way to do this?I used to use DTS in SQL Server 2000, but this seems to of dissapeared. I dont seem to have any similar tools installed.Thankyou |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2009-02-03 : 04:28:59
|
| if it's a 1 time thing you're as well off just using the import wizard.otherwise, assuming you're using 2005 or 2008, instead of DTS we use SSIS. you find it under programs, sql server etc... business intelligence development studioEm |
 |
|
|
matthisco
Starting Member
48 Posts |
Posted - 2009-02-03 : 04:36:18
|
| Thanks for your reply. I'm using 2005.Could you please tell me how you import?Thanks again |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2009-02-03 : 04:45:57
|
| you mean the wizard or using SSIS?for the wizard, right click on your database in management studio / object explorer. then go to tasks and import data...for SSIS, it's a little more in depth of course but if you've used DTS before you should be able to figure it out. try and if you get stuck with specifics come back hereEm |
|
|
|
matthisco
Starting Member
48 Posts |
Posted - 2009-02-11 : 05:15:13
|
| Thanks for your replies. Could you please tell me where the import wizard is?When I right click on the database, I dont get import data, I just get, detach, shrink, backup, restore. Thanks in advance |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2009-02-11 : 08:56:11
|
| what version of sql server are you using?Em |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-11 : 09:03:20
|
| http://www.mssqltips.com/tip.asp?tip=1055 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
|
|
Import Access Db to SQL server