Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Plz help me with exporting data into excel issue.

Author  Topic  evprince Starting Member 1 Post Posted - 2009-06-29 : 05:23:18 I use the following statement to export data from sqlserver into excel file.So far,it works well. What if i want to specify the positon in excel file? Like from position B5? Not from default A1? insert into openrowset('MICROSOFT.JET.OLEDB.4.0', 'Excel 5.0;HDR=YES;DATABASE=d:\test.xls', sheet1$) select * from #table Can anyone help me work out. Thanks in advance.