Import/Export

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Matt Dawson said:
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
Click to expand...

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
 
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!
 
Matt Dawson said:
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!
Click to expand...

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...ef=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.
 
Many Thanks Keith I will give it a shot!

Keith Wilby said:
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...ef=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.
Click to expand...
 
Back
Top