MS Access macro to export online table

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 423,885 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,212 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 4334 | Replies: 0

•

Join Date: Apr 2006

Location: OHIO

Posts: 1

Reputation: wescoent is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

wescoent

Offline

Newbie Poster

MS Access macro to export online table

Apr 8th, 2006

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