Search code examples
sql-serverexport-to-excel

Select From a Large table

I hava very large table with 1373228 rows. I need to copy the result to excel but It does not allow me to do so. Can anyone please, suggest me that how can select the table in parts and paste it in excel. I would really appreciate it.

Thanks a lot

Solution

  • Can't you do some export to a file using CSV for example? It should not be necessary to copy&paste. Export and import should work.