<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
Hello, <br />
I've tried all the settings found on internet to get my result in excel in separate column but I'm unable to make it works.<br />
Tools &gt;&nbsp;Options &gt;&nbsp;Custom delimiter.<br />
I tried with tab, I don't want that much with coma because I've comma in my textes. <br />
I wonder if it's because I've several tables in the results. <br />
<br />
Thanks for your help
</div>
</div>


Hello, 
I've tried all the settings found on internet to get my result in excel in separate column but I'm unable to make it works.
Tools > Options > Custom delimiter.
I tried with tab, I don't want that much with coma because I've comma in my textes. 
I wonder if it's because I've several tables in the results. 

Thanks for your help

SQL Server 2008 save to a file rpt with tab delimiter - Issue to open in excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.