I have a MS Access db that I use on my local machine to generate numerous reports etc. currently I am manually downloading a copy of the table from the online Microsoft SQL db which contains the data I use in generating these reports etc. I would like to link directly to the online table or create a macro that would down load an export from said table. So far I am having no success connecting from my current Acces db. I have connected via an Access project but that is another manual step.

Any Ideas.

Thanks