Export to Excel "Too many fields Defined"

Question

We have a request to export 10 tables to CSV flat file. When I do that, we get a file with columns that seem to break rows in exel. These columns contain commas, quotes and tabs.

So I then attempted to extract to excel 2007 format (from SQL 2005), but one of the tables says Error: too many fields defined.

Beyond removing commas, quotes and tabs programatically from those columns first, what are our options?

Thanks.

---

============================
Thank You
cyberpine.com

Answer 1

How many columns does the table from where you are exporting data have ? How are you trying to export to excel ? is it through SQL Mgmt Studio Query , SSIS or import/export wizard ?

---

Sanil Mhatre | Database Developer | MCTS | If you find my reply useful in any way, please vote it as helpful. If it has helped answer your question, please mark it as Answer.

Answer 2

Can you try the following approach  http://sethusrinivasan.wordpress.com/2012/04/06/export-the-query-to-excel-sheet-automatically/

Thanks

Sethu Srinivasan [MSFT]

SQL Server

http://blogs.msdn.com/sqlagent

Answer 3

Hi Cyberpine,

If you used OLEDB to export the tables, you have to notice that there is a limitation of columns using OLEDB. You can refer to this thread:

http://stackoverflow.com/questions/9189200/exporting-data-table-to-excel-using-oledb-throws-too-many-fields-defined-error

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 4

are you using SQL Server Data Import and Export Utility..??

---

------------------ Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Maqbool.