Hi Guys,

            I need to write data to an Excel template which has 2 sections. The section on top is the header and I write data to its individual cell using the following method:

UPDATE [Sheet1$C16:C16] SET F1 = 'some data'

 The other section, the section below header, has line items and each row is populated using the following method (same as above)

INSERT INTO [Sheet1$A29:BI29] (F1, F2, F3,.....F60) VALUES (1,'string data',20.34,.....,'another string data')

This method is working fine in my local machine i.e., writing the data on the intended Cell and Rows. My local machine has Microsoft Office Excel 2007 SP2 MSO. And the web application is developed using .NET Framework 3.5 SP1

But in case of production server, when using the same method, data are written elsewhere and are like scattered everywhere. My server has AccessDatabaseEngine.exe (version: 12.0.4518.1014) and .NET Framework 3.5 SP1 installed.

Can anyone please guide what i'm missing with the production server.

FYI: The excel template has images and objects. One more important information. When using excel 2003 file as template, both my local server and production server are working as intended. But the issue is that the template is huge in size around 3 MB. What i did is opened the template in Microsoft Office Excel 2007 and saved as xlsx version. The file size was reduced but it is not working perfectly only in case of production server.

So, I suppose I might me missing something in the production server.