October 30, 200124 yr Author While Importing from Excel I get these funny square elements in a text field.How do I get rid of them in my File Maker Field?I have tried to trim the data as well as try to substitute for carriage return,but to no use! Thank You
October 30, 200124 yr Jakob, what I usually do is first import into DBF format, and then into File Maker. Importing directly from Excel into FM hasn't worked well for me.
October 31, 200124 yr Those "funny square elements" are probably either higher-number ASCII characters that didn't import, or characters in a different font that didn't translate well into the font you're using. I've imported many Excel files into FMP with no problem -- in fact, it's much easier now that you can usually just open the Excel document within FMP, with no intermediate step necessary.
Create an account or sign in to comment