Trev, you could use LOAD DATA INFILE to import the spells file into MySQL, just don't forget to tell it to use '^' as a delimiter. Of course the schema has to match or you'll need to specify the fields you want.
I imported the spells file as a CSV into Excel myself and hid the fields I don't want to see. It gives me a nice, clean way to lookup spells.
|