RE: File Formatting exporting to Excel using BCP Command

SSC Guru

Points: 323504

August 28, 2015 at 8:27 am

nothing within SQL. SQL doesn't do files, technically.

SSIS or SSRS subscriptions can export data to native excel format.

otherwise, not really.. you have to use something external, like a CLR, Excel automation via sp_OaCreate, or third party dll or application.

if you have an existing template excel file, you could use a linked server to connect to it and insert/update/delete rows in that file.

if the file headers are dynamic, i'm not sure what you would do.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!