Convert VBA Excel 2007 Coding and Program to Visual Basic 2008 with SQL Database Populated with MS-Access

This should not be a difficult project. I have developed a program through Microsoft Excel 2007 VBA. The program uses separate workbooks to host the GUIs and code. It also has a separate workbook for the "Database" information( such as equipment information, operator information, etc.). The last workbook is the "Records" workbook. It is used to collect the data from the interfaces. I now need to convert the coding and database to a Visual Basic program so we can connect it to a MsSQL server. I've already made the Userforms. I have also already created the Access tables that will hold the database information and collect the complete data. So what I need is the code that will fill the userform with the data from the Access file through the SQL server, then update the data on the SQL server when a userform is completed. The SQL server will need to feed the data back to the Access database. And the Access database will need to be able to update the information on SQL. More details can be discussed if needed. Understanding of VBA, Visual Basic 2008, SQL servers and MS-Access 2007 is necessary.