Has anyone built a script to convert MS Access queries to views, stored procedures, or functions on SQL Server?

For those that have never dealt with Access, one of the features that lets you develop apps so quickly is the ability to insert VBA function calls into a query definition. Unfortunately, the number one feature that prevents you from upsizing to a "real" database server is the ability to insert VBA function calls into a query definition. The Access app in question has some 450+ (not a typo, and no I did not build it) queries that are used to generate reports. Eight of them upsized without modification.

That said, I have been slogging away at a script to make the changes (thanx again, zaxo & others, for the s/// help!). If somebody has already pulled this off and is willing to share their code, I would be very grateful. If not, I will keep at it and post the end result.

Thanx in advance!