Export Access Query data to specific Excel cells

[pookie312]

Hi!

I'm working with a password protected Access Database trying to export certain data from a query to specific cells in a preformatted Excel spreadsheet. I have a form in Access that I would like to add a button to to do this. Is this possible?

Any help is greatly appreciated!

 

[xlbo]

yup - have a search in the forum for previous posts - there are several that deal with this

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[pookie312]

Ok, I must not be searching for the right keywords because I can't find what I'm looking for. Can you help me out? Sorry, I'm new to all of this. Thanks in advance.

 

[xlbo]

Have a look at this thread for starters:

thread68-849548

searching on Access Query export excel brought up at least 20 decent examples

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question