topic Difference between excel files extracted from SAS and MS Access in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Difference-between-excel-files-extracted-from-SAS-and-MS-Access/m-p/49314#M724 <HTML><HEAD></HEAD><BODY><P> Please provide example if possible</P></BODY></HTML> Fri, 30 Mar 2012 03:47:30 GMT manojinpec 2012-03-30T03:47:30Z Difference between excel files extracted from SAS and MS Access https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Difference-between-excel-files-extracted-from-SAS-and-MS-Access/m-p/49313#M723 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have a work to export mobile phones in dataware house to excel files for SMS need.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Before sas, I use MS Access moudles to do it and it works.The upload platform for sending SMS recognize both text and numberic format for </P><P>mobile phone.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Now I write a macro to export excel files with mobile phone using character format.</P><P>&nbsp; The upload platform refuse to recognize the sas-output format.</P><P>I even try "'||'mobile phone'n ,don't work either.</P><P>My alternative solution is add a step as export to ms access in SAS.</P><P>Can any one here give a thought?</P><P>Thanks.</P></BODY></HTML> Fri, 30 Mar 2012 03:34:08 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Difference-between-excel-files-extracted-from-SAS-and-MS-Access/m-p/49313#M723 bbb_NG 2012-03-30T03:34:08Z Difference between excel files extracted from SAS and MS Access https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Difference-between-excel-files-extracted-from-SAS-and-MS-Access/m-p/49314#M724 <HTML><HEAD></HEAD><BODY><P> Please provide example if possible</P></BODY></HTML> Fri, 30 Mar 2012 03:47:30 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Difference-between-excel-files-extracted-from-SAS-and-MS-Access/m-p/49314#M724 manojinpec 2012-03-30T03:47:30Z