I am new to Access and SQL server. We are planning to migrate tables which are present in sharepoint to SQL server. Front end are access forms and visual basic to perform some events.Using access/vba,we insert data to sharepoint currently.But now insertion should happen in sql server. Linking of Access to SQL erver is sufficient or do we need to create connection objects in VBA. Kindly let me know the steps. Thanks in Advance.