You don’t give a reason why you want to use code rather than just import the tables. You can just import the tables from SQL Server into MS Access directly and save yourself a lot of work. Is there a reason why you want to use code to perform this function?
*****
Yes, I fully agree & concur.
Access 2007 has made importing very simple. Just click External Data, & then Import . You can choose from a variety of sources – Excel, Lotus, SQL, Access, Word etc.