PRB:Can't Export Data w/Extended Characters to Microsoft ExcelLast reviewed: May 16, 1996Article ID: Q139160 |
The information in this article applies to:
SYMPTOMSSome Macintosh extended characters do not transfer correctly to Microsoft Excel with the COPY TO...TYPE XLS command. Using a tab-delimited or SYLK file type does hold this formatting correctly. Extended characters are created by holding the option key and then pressing another key. When converting some extended characters (such as the bullet created with the key sequence "Option-8" or smart quotes created with "Option-[", "Option-]", "Shift-Option-[", and "Shift-Option-]"), the COPY TO <file> TYPE XLS doesn't bring these characters over correctly. This behavior might be related to the fonts used but appears to be more than that in this case.
RESOLUTIONTo export extended characters, export the file as tab-delimited text. This requires you to verify the format of the fields. In particular, Microsoft Excel treats date fields as a General format, and places a number with the format yyyymmdd. Another possibility is to copy the data with a SYLK format:
STATUSMicrosoft is researching this behavior and will post more information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATION
Steps to Reproduce Behavior* The following code creates a table and adds some extended characters. * It then converts the data into Microsoft Excel format. The characters * from the FoxPro table are not reproduced correctly in Microsoft Excel. * CREATE TABLE XLTEST (CHAR C(10),DATEFLD D(10)) INSERT INTO XLTEST VALUES (CHR(165),{01/01/95}) INSERT INTO XLTEST VALUES (CHR(210)+CHR(211),{01/01/95}) BROWSE NOWAIT COPY TO XLTEST.XLS TYPE XLS |
Additional reference words: 2.60a FoxMac
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |