There are four ways I can think of right now:
1) from the "target system" (Excel or Access), connect to the SQL Server and select the values you need,
2) use T-SQL and look into bcp command with queryout option in BOL (BooksOnLine),
3) use the export wizard in Management studio (right click on the database) or
4) create an SSIS export package.
There are quite a few samples described in this forum. I'd recommend you search for "export Excel" and the option you'd like to use.
Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]