Friday, April 13, 2012 6:27 PM
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?
Friday, April 13, 2012 7:33 PMHow 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.
Friday, April 13, 2012 8:41 PM
Can you try the following approach http://sethusrinivasan.wordpress.com/2012/04/06/export-the-query-to-excel-sheet-automatically/
Sethu Srinivasan [MSFT]
Monday, April 16, 2012 9:22 AMModerator
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Monday, April 16, 2012 11:10 AM
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.