[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 151
  • Last Modified:

How or can you save or export an SQL Server 2008 table to a Microsoft Excel File?

I am running MS SQL Server 2008. I use it in connection with a Visual Basic 2008 program that I put together using Visual Studio 2008/SQL Server 2008. My customer wants me to send her inventory in a Microsoft Excel spread sheet. I have been sending PDF files from my program. I was thinking that maybe I could some how pull the spreadsheet directly out of SQL server. Is there any way I can give her the Excel spreadsheet?
0
jampost
Asked:
jampost
  • 2
2 Solutions
 
Éric MoreauSenior .Net ConsultantCommented:
0
 
Lee SavidgeCommented:
In management studio, type "select * from mytable". Before running it press Ctrl D to make the results appear as a table then in the results pane right mouse click on the little blank square to the left of the column names anad choose save results as, and it will save as csv
0
 
jampostAuthor Commented:
I want to thank Emoreau & Isavidge for your help.  Isavidge's comment worked best because it walked me through the process in laymans terms - straight forward & accurate .  Thanks again.   --   Joe
0
 
Lee SavidgeCommented:
Glad to help.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now