I just spent the last day converting data from a legacy access application to My Rails app (back end "dictated" db ms-sql), It was a tedious exercuise using Access and MS's Managment Studio.
Years ago developed an application that could access any ADO database using a common interface. So I developed it again, but made it better. Conversion was a breeze. This tool affectionately called ADOExploer is available here ADO Explorer Page. Feedback so-far has been good, enjoy