"Keith Wilby" wrote:

> "Matt Dawson" <MattDaw***@discussions.microsoft.com> wrote in message
> news:1EC42755-6690-472B-AD0B-E001CC7D490C@microsoft.com...
> > Does anyone know how to Import data to Excel from Access when I have user
> > group security.
> >
> > I want to import from a query/form and it says I do not have the
> > permissions. DOes anyone know a way round this
> >
> > Many Thanks,
> >
> > Matt
>
> You could always push the data into Excel from Access instead of trying to
> use Excel to pull it from Access.  To do it your way you'd need a way of
> authenticating else the security would be useless.
>
> Regards,
> Keith.
> www.keithwilby.com
>
>
>

"Keith Wilby" wrote:

> "Matt Dawson" <MattDaw***@discussions.microsoft.com> wrote in message
> news:4A40CB6E-8A55-4439-ABFB-4AF9089DC0FA@microsoft.com...
> >I am willing to try anything?
> >
> > How would I do this? I need the data to be linked though or else it will
> > defeat the whole object!
> >
>
> If you don't have SP2 applied to MS Office then you can use the linked
> tables method.  Use the linked table manager to browse to your Excel file
> and then use it within Access as if it was a linked table.
>
> If you do have SP2 applied to MS Office then the linked table method is
> read-only and you will have to use Office Automation instead.  This is
> essentially setting a library reference to Excel from within an Access code
> module window and using VBA code to control your Excel spreadsheet from
> within Access.  What's in the code will of course depend upon what you want
> to do but a good starting point might be to Google for "Office Automation"
> to get some background.
>
> I learned how to use automation by reading this book, "Integrating Excel and
> Access":
>
> http://www.amazon.co.uk/Integrating-Excel-Access-Michael-Schmalz/dp/0596009739/sr=8-1/qid=1161177427/ref=sr_1_1/026-7788857-3343605?ie=UTF8&s=books
>
> That's a genuine recommendation, I'm not affiliated with the authors or
> publishers in any way.
>
> Good luck.
>
> Keith.
>
>
>