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.
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply