Before spending $300 on FM Pro...
I suggest downloading the 30 day free trial to get a feel for FileMaker.
1) FileMaker can import data from a number of basic file types. You can export either tab, csv or an excel file format to produce a data file that can be imported into FileMaker. The import process can import data into an existing table or it can be used to create a new table in your file. Once the data is imported, you can sort, search as needed to work with the data.
2) A fairly simple conditional format expression that uses GetNthRecord to compare the value in the current record to the value of the same field in the preceding record can make the text only visible for the first such record in a group with the same value.
Assuming that iTunes will not serve your purposes....
Download the 30 day trial - there are templates included - one is music library
Add the fields needed to match your old databases.
Export the access databases to excel or comma deliminated.
Open the excel or csv in filemaker - it will create a database with your data.
Name or rename the fields in the new database to match the names in the Music Library database from template.
Import the data.
This list of FMP links may be useful
For printing reports, you can use the Sub-Summary when sorting by… Part to accomplish the same thing. It wouldn't print like your Table format, but it would be a header over the table (body) either underneath or above. Which, you can make look better than a table (spreadsheet) view of your data.
For point #1, like what was mentioned by the other 2 commenters, you can import an Excel spreadsheet directly into FileMaker Pro. If you have multiple "sheets" in your Excel spreadsheet, you would need to import each separately.
There is a learning curve in figuring out all the possibilities with FileMaker, but once you learn, you will find out it is far more powerful.
Thanks for all of your responses to my post - believe that I will likely have to do a 30-day DL trial and 'test' out my needs, including the report printing - will do soon. Dave :)