HELP

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

Guest

H
I'm in the process of desiging a membership database for my church and they want to be able to export certin fields of this database to an excel spread sheet. I would like to place an Item on the switch board that when they click on it that it will do this. Can someone tell me how to do this or can someone direct me to a tutorial of how I can so this. If there is a better way please make suggestions

thank you for your help...
Tom
 
tom said:
I'm in the process of desiging a membership database for my church and
Click to expand...
they want to be >able to export certin fields of this database to an excel
spread sheet. I would like to place >an Item on the switch board that when
they click on it that it will do this. Can someone tell >me how to do this
or can someone direct me to a tutorial of how I can so this. If there is
a better way please make suggestions.
Click to expand...

i would use a query and in that query use only those fields you need in
excel spreadsheet..

then you can make a macro command and chose as action OutputTo uner object
type select query and under object name select the query you made, under
output format chose ms excel... and thats it... you can make it to auto open
that new excel file in msexcel after generating it...

i hope this helps....

andy
 
tom said:
Hi
I'm in the process of desiging a membership database for my church and
Click to expand...
they want to be able to export certin fields of this database to an excel
spread sheet. I would like to place an Item on the switch board that when
they click on it that it will do this. Can someone tell me how to do this or
can someone direct me to a tutorial of how I can so this. If there is a
better way please make suggestions.

First build a query with the fields you want to display in Excel. If you are
not familiar with using VBA code (the OutputTo method) for sending the query
to Excel, you can also use the OutputTo macro action or you can also use the
Office Links item on the Tools menu, and click "Analyze It With MS Excel"

You can also use TransferSpreadsheet (both code, method or macro, action) on
a query.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top