limitation for excel rows when exporting in BCP

Question

Hi,

I am trying to export more than 100000 rows to .xlsx using BCP but it generated the output with empty excel sheet.  I am wondering is there any limitation for exporting no. of rows using BCP?

---

ESHANI. Please click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

Answer 1

Can you check out below link.

http://mvark.blogspot.com/2009/08/exporting-to-excel-with-bcp.html

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 2

Hi Eshani

Try to use .xls instead of xlsx.

---

Mark as Answer If Reply Was Helpful
Thanks
Kuldeep Bisht
Technical Lead @ Simplion Technologies
Blog : www.dbsimplified.com

Answer 3

BCP cannot produce .xlsx or .xls files. Well, you can always put that file ending on the file, but Excel will not recognise the files.

If you want to generate files from BCP that Excel can read, use .CSV files with comma or semicolon as separator. (Which to use depends on your regional settings.)

If you want to produce full-fledged Excel books, use SSIS or OPENROWSET with the Jet provider.

---

Erland Sommarskog, SQL Server MVP, [e-mail]