Export to Excel

Getting started with SSIS - Part 1: Introduction to SSIS

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Home | Ask Question

Ask in the public forum

Profile

Ask your questions in a public forum

My Blog Posts

Recent Blog Posts

Mar 9 2010 11:54PM |

I want to export my data from SQL to excel.

I fetch my data through sql query and save results to an excel file always in this query itself.

So help me out in this guys.

GeekInGoa

805 · 0% · 18

4 Replies

Subscribe to Notifications

You can use OPENROWSET to perform this

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\testing.xls;',
'SELECT * FROM [SheetName$]') select * from SQLServerTable

Replied on Mar 11 2010 3:00AM .

Madhivanan

3 · 34% · 5789

Hi,

Excel has limitation to 65k rows so how it extracts more than 65k rows?

Is it split to another cell?

Thanks

Replied on Mar 19 2010 8:55AM .

poratips

639 · 0% · 25

[quote user="poratips"]

Hi,

Excel has limitation to 65k rows so how it extracts more than 65k rows?

Is it split to another cell?

Thanks

[/quote]

Use versions starting from 2007

Yes. You can also split data to cell perhaps you can apply pagination technique

Refer point 4

http://beyondrelational.com/blogs/madhivanan/archive/2007/08/27/multipurpose-row-number-function.aspx

Replied on Mar 22 2010 11:08AM .