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.
Last Wiki Answer Submitted: November 26, 2008 4:38 pm by Tjones180 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.