Post reply

Export a table to Excel(2010)

  • March 16, 2016 at 12:47 pm

    #305736

    Hi,

    I was trying to export a table which has 2.5 million records to excel 2010 and it failed since Excel 2010 only holds 1 million records, etc.

    I also tried to save as .csv file and same issue.

    Is anyone else can think of any other way to get this exported?

    Regards,
    SQLisAwe5oMe.

  • March 16, 2016 at 12:51 pm

    #1865710

    exporting to csv is no problem, even if there is 2.5 million rows.

    opening it IN EXCEL is an issue, since it will not support that many rows.

    open it in a flat file text editor instead, like UltraEdit which i KNOW handles huge files, or solid text editors like EditPlus/Notepad++ instead.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 16, 2016 at 1:17 pm

    #1865717

    Okay, Thanks Lowell.

    Regards,
    SQLisAwe5oMe.

Viewing 3 posts - 1 through 2 (of 2 total)

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