This page give a "Cheat sheet" of language conversion between MS Access and SQL Server:
<a href="http://weblogs.sqlteam.com/jeffs/archive/2007/03/30/Quick-Access-JET-SQL-to-T-SQL-Cheatsheet.aspx"> Cheat sheet</a>
Here is a site that promises some VB code that will convert data either way:
<a href="http://www.a1vbcode.com/app-2612.asp">VB code</a>
Last Wiki Answer Submitted: August 1, 2008 3:17 pm by Flame14,895 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.