By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

database records to excel sheet

P: n/a
Here is what I'd like to do:

I type in a query in MS Access form. The result is a list of names. I
want to put those names in MS Excel Sheet. How do I do that? I'd
appreciate any help. Thanks.

Regards,
koobel

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
<ko******@hotmail.com> wrote in message
news:11*********************@l41g2000cwc.googlegro ups.com...
Here is what I'd like to do:

I type in a query in MS Access form. The result is a list of names. I
want to put those names in MS Excel Sheet. How do I do that? I'd
appreciate any help. Thanks.

Use the Tools/Office Links "Analyze it with Excel" menu option.

Regards,
Keith.
www.keithwilby.com
Nov 13 '05 #2

P: n/a
When viewing the query results, choose Export from the File menu.

If you need to do it programmatically (e.g. whenever the user clicks a
button), create a macro, and use the TransferSpreadsheet action.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ko******@hotmail.com> wrote in message
news:11*********************@l41g2000cwc.googlegro ups.com...
Here is what I'd like to do:

I type in a query in MS Access form. The result is a list of names. I
want to put those names in MS Excel Sheet. How do I do that? I'd
appreciate any help. Thanks.

Regards,
koobel

Nov 13 '05 #3

P: n/a
> If you need to do it programmatically (e.g. whenever the user clicks
a
button), create a macro, and use the TransferSpreadsheet action.


Thanks for the hint. Correct me if I'm wrong but TransferSpreadSheet
allows exporting only tabular data to an Excel spreadsheet. I need to
send results to specific cells in an existing spreadsheet which are not
placed in tabular order.

Regards,
Koobel

Nov 13 '05 #4

P: n/a
Yes, you're right.

The simplest solution would be to create a query that does export the fields
in the correct order, and/or have the Excel sheet pick up the values from
another sheet that contains the exported data.

Beyond that, it is possible to write individual cells in Excel, but that
involves quite a bit of code. If that's what you need, post back and perhaps
someone else can give an example.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ko******@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
If you need to do it programmatically (e.g. whenever the user clicks

a
button), create a macro, and use the TransferSpreadsheet action.


Thanks for the hint. Correct me if I'm wrong but TransferSpreadSheet
allows exporting only tabular data to an Excel spreadsheet. I need to
send results to specific cells in an existing spreadsheet which are not
placed in tabular order.

Regards,
Koobel

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.