Member Avatar for wescoent
wescoent 0 Newbie Poster

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

  • 1 Contributor
  • 0 Replies
  • 66 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.