dynamic excel file creation

Question

question

pmanoj asked Dec 26, '11

dynamic excel file creation

Hi I have one requirement where we have to create dynamic excel file in sql server integration services and then store that excel file in database table

excel dynamic file

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2011-12-28T02:16:36Z

sameer 1 answered Dec 28, '11

try checking this article by jstrate: http://www.jasonstrate.com/2011/01/31-days-of-ssis-instant-excel-spreadsheet-1431/ This might be of some use to you.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

pmanoj commented · Jan 02, 2012 at 11:02 PM

I am able to create excel but problem is how to store excel file in sql table.

0 ·

Answer 2 · 2012-01-02T23:26:54Z

Sharma answered Jan 2, '12

Hope this could help you- > CREATE TABLE dbo.ExcelDoc(FileName > VARCHAR(255) NOT NULL,FileContent > VARBINARY(MAX) NOT NULL); > > > INSERT INTO dbo.ExcelDoc (FileName, > FileContent) SELECT 'SalesData', > BulkColumn FROM OPENROWSET(BULK > 'C:\Test.xls', SINGLE_BLOB ) > as DocFile; > > > SELECT * FROM dbo.ExcelDoc > > > DROP TABLE dbo.ExcelDoc

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

pmanoj commented · Jan 04, 2012 at 10:47 PM

Thanks amardeep hope it helps me

0 ·

question