Awesome Guru I enjoyed watching this video and recommend other. Thanks for educating the community and appreciate your volunteership. Question How to export from table or query to multiple Excel files Example In Adventure works There is a Prod Category and Prod table I would like to group the query by Category like Bikes, Components etc and export each group to separate Excel file? You being a Guru please do you have video or any advise/idea? Or from SSIS how to export from one source to multiple destination excel files? Thanks a bunch
yes, thanks for explaining the diff between 32-bit to 64-bit SSMS that invokes 32-bit xls engine. This helped me when extracting over 100K rows.
This video was very useful, nice tip about the gotcha :)
Genius! Thanks!
please organize yr video in playlist
Awesome Guru
I enjoyed watching this video and recommend other.
Thanks for educating the community and appreciate your volunteership.
Question
How to export from table or query to multiple Excel files
Example
In Adventure works There is a Prod Category and Prod table I would like to group the query by Category like Bikes, Components etc and export each group to separate Excel file?
You being a Guru please do you have video or any advise/idea?
Or from SSIS how to export from one source to multiple destination excel files?
Thanks a bunch
How to export blob files to hard drive?