Answered by:
How to export to excel

Question
-
Hello all,
I have one requirement which takes an excel file from CRM information as input to a custom application.
I try to use standar export funtionality but when I save it, it generates another format like code shows. And this "excel" format can not be read using Oledb connection :(:(
Why crm does not generate a normal excel ... or I am missing any configuration ?<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta name="Excel Workbook Frameset"> <meta http-equiv=Content-Type content="text/html; charset=unicode"> <meta name=ProgId content=Excel.Sheet> <meta name=Generator content="Microsoft Excel 12"> <link rel=File-List href="Account%20Advanced%20Find%20View2_files/filelist.xml"> <![if !supportTabStrip]> <link id="shLink" href="Account%20Advanced%20Find%20View2_files/sheet001.htm"> <link id="shLink"> <script language="JavaScript"> <!-- var c_lTabs=1; var c_rgszSh=new Array(c_lTabs); c_rgszSh[0] = "Account Advanced Find View"; var c_rgszClr=new Array(8); c_rgszClr[0]="window"; c_rgszClr[1]="buttonface"; c_rgszClr[2]="windowframe"; c_rgszClr[3]="windowtext"; c_rgszClr[4]="threedlightshadow"; c_rgszClr[5]="threedhighlight"; c_rgszClr[6]="threeddarkshadow"; c_rgszClr[7]="threedshadow"; var g_iShCur; var g_rglTabX=new Array(c_lTabs); function fnGetIEVer() { var ua=window.navigator.userAgent var msie=ua.indexOf("MSIE") if (msie>0 && window.navigator.platform=="Win32") return parseInt(ua.substring(msie+5,ua.indexOf(".", msie))); else return 0;
YojanFriday, January 15, 2010 11:06 PM
Answers
-
You can certainly open it up in Excel and save it as 'proper Excel'
Leon Tribe
Want to hear me talk about all things CRM? Check out my blog
http://leontribe.blogspot.com/
or hear me tweet @leontribe
Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe- Proposed as answer by Leon TribeMVP Tuesday, January 26, 2010 8:55 PM
- Marked as answer by Yojan Thursday, January 28, 2010 4:49 AM
Tuesday, January 26, 2010 8:54 PM
All replies
-
CRM generates openxml format, not 'proper' Excel. I'm not sure which ODBC connector will work for this, maybe the FoxPro one?
Leon Tribe
Want to hear me talk about all things CRM? Check out my blog
http://leontribe.blogspot.com/
or hear me tweet @leontribe
Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe- Proposed as answer by Leon TribeMVP Saturday, January 16, 2010 2:32 AM
Saturday, January 16, 2010 2:32 AM -
you can use xml parse the excel file. then load to dataset or griddataviewSaturday, January 16, 2010 5:20 AM
-
uhmm ..supposly end users are supposed to edit this excel file format .... and after this modification is done it is uploaded to custom application.
so as I understand, they need to save it in another file name with the correct format ... or am I wrong ?
YojanSunday, January 17, 2010 9:45 PM -
You can certainly open it up in Excel and save it as 'proper Excel'
Leon Tribe
Want to hear me talk about all things CRM? Check out my blog
http://leontribe.blogspot.com/
or hear me tweet @leontribe
Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe- Proposed as answer by Leon TribeMVP Tuesday, January 26, 2010 8:55 PM
- Marked as answer by Yojan Thursday, January 28, 2010 4:49 AM
Tuesday, January 26, 2010 8:54 PM