Re-save the worksheet as a CSV file ensuring to change the from to does not appear and the file is immediately opened in Excel.The file should now open correctly in Excel with all fields properly delimited.The Excel will be immediately displayed at which point the file must be identified as beingī) set the delimiter to a “comma” (the default is so be sure to uncheck that option after selecting.If this is the cause of the problem, it can be easily identified by opening the CSV file in Excel which will result in one of the two following things to occur Scenario #1 This file generates a MAPI translation error when attempting to import it into Outlook. (aka Windows Live Mail, Hotmail etc) generates a unicode text file when exporting contacts to a CSV text file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |