November 16, 2009 at 4:46 am
Hi i want export a table into database to a excel file
i search s command in Sql Server That help me Export a Table in Excel File without create file manully
please guide me
November 16, 2009 at 9:51 am
Use the Import/Export Wizard in SQL Server Management Studio. It will create the Excel file before exporting data. See "SQL SErver Import and Export Wizard" in BooksOnLine.
Greg
November 16, 2009 at 8:27 pm
Hi Thank you
i already use export and import wizard but i want accomplish this job by Sql command
November 17, 2009 at 6:05 am
You can also create a SSIS package (for example using the wizard recommended) or bcp out to a .csv file.
November 18, 2009 at 2:31 pm
https://www.sqlservercentral.com/blogs/vinaythakur/archive/2009/10/23/tricks-and-issues-part-1.aspx
HTH
Vinay
http://vinay-thakur.spaces.live.com/blog/cns!645E3FC14D5130F2!591.entry
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply