Export Data from SQL to Excel

• JStevenson1

  SSC-Addicted

  Points: 484

  More actions

  July 21, 2010 at 7:44 pm

  #223520

  I have little over 100,000 records in a table and I'd like to be able to export data from SQL to Excel. It does not have to be in a single file. Is there a way to select first 60,000 record using a query and then extract remainder of records?

• kabaari

  SSCrazy

  Points: 2235

  More actions

  July 21, 2010 at 8:50 pm

  #1196611

  If you're using SSIS to export you can write the query when asked Copy table or Write Query.

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  July 21, 2010 at 8:58 pm

  #1196613

  If you will be using SSRS then this info might help

  How to: Add a Page Break (Reporting Services)

  http://technet.microsoft.com/en-us/library/ms156434.aspx

  If above is not satisfactory .. please post asking for additional assistance, specifying what you will be using for the export.

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• torpkev

  SSCarpal Tunnel

  Points: 4819

  More actions

  July 23, 2010 at 9:29 am

  #1197578

  Why not just use bcp? Its easy to do.. Open a command (the black dos type window) window and run the command..

  bcp <yourdb>.<yourschema>.<yourtable> out <filename> -c -t, -T -S<servername> -F<firstrow> -L<lastrow>

  Heres an example of pulling 100 records from a table in a test database of mine..

  bcp hookDB.dbo.hook_ctrhistory out c:\ctrhistory.csv -c -t, -T -Slocalhost -F1 -L100

  --------------------------

  I long for a job where my databases dont have any pesky users accessing them 🙂