I wish to migrate a mineralogical database that I created using v5.5 for use with v9 Advanced, but a straight import loses all the special formatting for the chemical formulae. Is there a way to import the data while preserving the formatting so that I don't have to reformat 3000 formulae?

I am not sure what you mean by "straight import". You cannot import directly from a .fp5 file. But if you let Filemaker v.9 convert the .fp5 file, the text styling will be preserved - even if you then import the data to another file.

Just opened the fp5 file and let v9 convert it - and the superscript and subscript formatting is gone from the formulae.

Can you post a sample .fp5 file? A copy of your file with just the relevant field and one or two records with example data should be sufficient.

here it is

Edited July 6, 200817 yr by Guest

Converts fine retaining formating for me FM9 advanced on OSX Tiger.

hmmm - must be something with the Windows versions not retaining super/sub formatting.

oh well - looks like I'll have to edit each formula individually anyhow - thanks for the attempt :

check your PM box, I can send you the converted file, perhaps it will work for you.