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: 246985 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.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

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: 76996 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: 246985 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.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Jeff Moden SSC Guru Points: 1004406 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)