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
 General SQL Server Forums
 New to SQL Server Programming
 table - excel

Author  Topic 

dwholloway
Starting Member

1 Post

Posted - 2009-09-05 : 11:18:15
Would one of you guys or gals help me. I am trying to export a table to excel. Afterwards I want to import it back.

Dennis

shah429
Yak Posting Veteran

52 Posts

Posted - 2009-09-05 : 13:06:16
Sure,there are a couple of options.
1. Use SSIS(if you are on 2005) or DTS(if you are on 2000)
2. Use Bulk Copy (if you are not familiar with option 1)

If you are not familiar with both the options, do Google.
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-09-05 : 13:21:40
The google custom search box on this site brings up many threads for this.
For example:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -