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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Import Excel data

Author  Topic 

abhiutd
Starting Member

1 Post

Posted - 2009-04-06 : 14:36:20
Hi,
I used to Import/Export using the DTS wizard in 2000 so easily by right-clicking on a table but in 2005 i dont see that option. Can someone give me pointers to achieve the same.

Thank You.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-07 : 01:51:46
Righ click on Database-->Tasks-->Export data

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

svicky9
Posting Yak Master

232 Posts

Posted - 2009-04-08 : 04:22:04
(Window+R) -->DTSWIZARD

http://www.sqlserver007.com
Go to Top of Page
   

- Advertisement -