problem with expoting data to excel

I have a problem while exporting the crystal report to Excel sheet.
I am trying to display running total at the end of my report(In the report footer). It is displayed in several lines using a formula field. I have used appended chr(13) within the formula to break the values into different lines. But finally when I am exporting the report to excel all the lines are displayed in a single cell. What should I do to display them in multiple cells when exported to excel. Is there any ascii value which can be used instead of chr(13) , which will help me print the values in different cellsIf you use chr(13), it will be exported to the same cell. Instead use seperate formula to have the value and place it next to first formula

Problem with DTSX

I am trying to execute an DTSX for Exporting data from SQL 2005 to Access Database. From SQL Wizard, the Export process is running fine.

When I tried to execute the same using an Stored Procedure (
XP_CMDShell 'dtexec /F E:\Shared\Export\Export_Fame_Entity.dtsx') it is getting executed for long time.. but never gets completed and thus, not giving any error also.

Help required.........

regards,
Ravi K
Mascon Global Limited

In SQL Server 2005 the xp_cmdshell is disabled in new installations. This may be your problem. The Books Online topic, Surface Area Configuration for Features, rovides more information about enabling xp_cmdshell.

Also it looks like your command line is missing quotes. Try using "E:\Shared\Export\Export_Fame_Entity.dtsx"
I ran a package successfully from the Query window in SQL Server Management Studio using the following syntax
xp_cmdshell 'dtexec /f "C:\UpsertData.dtsx"'
The SQL Server 2005 Books Online topic, dtexec Utility, provides a wealth of information about running packages by using dtexec.

Marianne
SQL Server User Education
This posting is provided "AS IS" with no warranties, and confers no rights.