I have the following SP that will email me an attachment of the results of a specific query:
@profile_name = 'PROFILE',
@recipients = 'MY@EMAILADDRESS',
@query = 'EXEC USP_SP',
@subject = 'DATA',
@attach_query_result_as_file = 1,
@query_result_separator ='' ,
@query_result_no_padding = 1,
@query_attachment_filename = 'ACCESS.XLS';
When I open the attachment obviously each data element is separated by a space but all elements are in 1 column. Is there a way to separate each element into its own column?
Thanks in advance for your help.