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

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
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
There is imho no other way than using the Text import wizard.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim HornSQL Server Data DudeCommented:
Agree with the above, but two other options are..

1)  Create an SSIS package that executes the report's data source, formatting text columns with a " text delimenter (assuming there are no "s in your text columns), and export to .csv, which I'm guessing can be opened by Excel correctly.

<Vastly more complex>
1) Create an Excel 'template' file formatted how you want, with VBA code in the Startup (?) macro that formats data dumped into it exactly how you wish.
2) create an SSIS package that ...
   2a) Copies the 'template' file to a location SSIS will use as the destination
   2b) Executes the report's SP data source to the above Excel destination.
   2c)  Open the Excel file, which executes the Startup macro to format the data.
   2d) Close the Excel file.
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.