Using Analyze It with MS Excel

  • Thread starter Thread starter jdtivoli
  • Start date Start date
J

jdtivoli

Using the "Analyze It with MS Excel" function to export
access data from a form to an Excel workbook, it
automatically creates a workbook with the same name as the
form in Access that the data comes from.

Is there any way to specify a particular workbook to
export the access data to?
Or is there perhaps a better way all together, rather than
using the Tools\Office links\Analyze It with MS Excel
feature?
 
Yes the Analyze It with MS Excel is the same as the OutputTo Method of the
DoCmd object. You can also use the TransferSpreadsheet Method. Both are also
available as macros, albeit without any error handling capability. Have a
look in the help files for those keywords.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top