Friday, February 27, 2009

Import data with unicode content from Excel

Remove row containing field(column) names if any
Use Excel to save file as comma-delimited (.csv)
...must be done on computer with support for particular Asian language enabled
Rename extension to .txt
If question-mark appear instead of space, use Find-Replace of a text editor to fix it
Use Foxpro's Import Wizard to import from Text file

No comments:

Post a Comment