Exporting Basics

[Public]

Hi,
I just want to begin exporting some data to Excel Sheet. I just want to know
the basics of it. I want to know if I want to export two text boxes in a form
to an Excel sheet (each textbox with its label is a line), how can I do that?

Regards

 

[Klatuu]

You don't export forms. You export either tables or queries. Most will
usually use queries to filter what records get exported.
To get the basics of exporting to Excel, see TransferSpreadsheet in VBA Help.

 

[Jeanette Cunningham]

here is some info from The Access Web
http://www.mvps.org/access/reports/rpt0019.htm


here is some code that takes 2 text box values from an access form and puts
them in a spreadsheet
http://www.mvps.org/access/modules/mdl0006.htm


Jeanette Cunningham -- Melbourne Victoria Australia