SQL SERVER
-
Hi, I am trying to Export Data From SqlServer Table Into Multiple Excel Worksheets. I have more than 65000 records which can not fit into one Excel worksheet. I am using BCP command in a stored procedure to export. I have searched in google and could not get solution to export to mulitple sheets from stored procedure. Please let me know if anyone can help me on this. Thanks for helping.
-
Hi, I am trying to Export Data From SqlServer Table Into Multiple Excel Worksheets. I have more than 65000 records which can not fit into one Excel worksheet. I am using BCP command in a stored procedure to export. I have searched in google and could not get solution to export to mulitple sheets from stored procedure. Please let me know if anyone can help me on this. Thanks for helping.
What I would do is create ranges to export. For example, say the data is customer data, you could easily create 26 separate files by exporting customers by the first letter of their last name. Create an A file, B file, etc. If your table is accounting in nature, use ranges of the account numbers. Ex: Account: 1000-1999, 2000-2999, etc
-
What I would do is create ranges to export. For example, say the data is customer data, you could easily create 26 separate files by exporting customers by the first letter of their last name. Create an A file, B file, etc. If your table is accounting in nature, use ranges of the account numbers. Ex: Account: 1000-1999, 2000-2999, etc
-
Thank you for your answer. I am looking at the same Excel File with different sheets. Please let me know.
You can still divide the data extract into multiple extracts, then import them into individual sheets. Maybe I didn't understand your problem. :confused: I thought you were extracting data, then manually importing it into Excel, but after reading your question again I see that you are exporting data directly into Excel. I would still break your extract into multiple chunks and import those chunks into separate worksheets in the same Excel workbook. Take a look at this article, maybe it will be helpful ... http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926[^]