I am only recently getting into SQL (microsoft 2003 and 2005) but have several vb code snippets (mainly vb6), functions etc. that would be great if I could transform automatically into SQL or use ActiveX files created from them.

Is this a possibility and if so is there an easy way to import/convert?

Some code simply works on access databases and or excel and where possible it would be much neater to have the dbase and code in SQL.

Any help would be appreciated.