Import MIllion rows into Excel

Question

Import MIllion rows into Excel

sathwik.em91

SSC Eights!

Points: 878
More actions
August 20, 2018 at 2:34 pm

#362180

Hi Team,
I am trying to copy 2 million + rows from sql server Grid view to Excel spreadsheet.Its not allowing me to do that.Is there any alternative way I can copy them??
Thanks
SE

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246686 More actions · Answer 1

sathwik.em91 - Monday, August 20, 2018 2:34 PM
Hi Team,
I am trying to copy 2 million + rows from sql server Grid view to Excel spreadsheet.Its not allowing me to do that.Is there any alternative way I can copy them??
Thanks
SE

It's an export, not an import. Use a CSV file instead.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

sathwik.em91 SSC Eights! Points: 878 More actions · Answer 2

Phil Parkin - Monday, August 20, 2018 2:46 PM
sathwik.em91 - Monday, August 20, 2018 2:34 PM
Hi Team,
I am trying to copy 2 million + rows from sql server Grid view to Excel spreadsheet.Its not allowing me to do that.Is there any alternative way I can copy them??
Thanks
SE
It's an export, not an import. Use a CSV file instead.

I have the same error when I try to export into .csv file.

drew.allen SSC Guru Points: 76944 More actions · Answer 3

sathwik.em91 - Monday, August 20, 2018 2:53 PM
Phil Parkin - Monday, August 20, 2018 2:46 PM
sathwik.em91 - Monday, August 20, 2018 2:34 PM
Hi Team,
I am trying to copy 2 million + rows from sql server Grid view to Excel spreadsheet.Its not allowing me to do that.Is there any alternative way I can copy them??
Thanks
SE
It's an export, not an import. Use a CSV file instead.
I have the same error when I try to export into .csv file.

Excel only supports 2^20 rows (1,048,576). Depending on exactly what you are trying to do, you may be able to use PowerPivot.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

Phil Parkin SSC Guru Points: 246686 More actions · Answer 4

sathwik.em91 - Monday, August 20, 2018 2:53 PM
Phil Parkin - Monday, August 20, 2018 2:46 PM
It's an export, not an import. Use a CSV file instead.
I have the same error when I try to export into .csv file.

Please provide the full text of the error message.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 5

sathwik.em91 - Monday, August 20, 2018 2:34 PM
Hi Team,
I am trying to copy 2 million + rows from sql server Grid view to Excel spreadsheet.Its not allowing me to do that.Is there any alternative way I can copy them??
Thanks
SE

Why, on this good Green Earth, would you want to do such a thing? SQL Server has plenty of horsepower to return reporting results that you can use in EXCEL. Just exactly how long do you think it will take to do such an analysis or whatever it is you're trying to do in Excel? For that matter, what makes you think the machine you have Excel installed on actually has the memory capacity for such a thing?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)