The Song Table database gets loaded from a set of files, generally one for each hymnbook. The format of the ones I've seen is a set of records of the form

0000 | Not in

nnnn | Title with spaces

...

nnnn | Title with spaces

9999 | End of Songs

Where nnnn is a number with a variable number of digits, although generally with leading digits. The database Song table should be filled in with Index as a new unique index, Book as an abbreviation for the book that the file refers to, Number as the integer(zero stripped) number in the first column, Type as "Psalm" or "Song" depending on a rule for the title, and Title as the Title given after the vertical bar, suitably stripped of leading and trailing spaces.