Export subform datasheet information to excel

  • Thread starter Thread starter Brandon Johnson
  • Start date Start date
B

Brandon Johnson

How do i take data that is in datasheet view in a subform and export it
to an excel file? Ive tried an outputto macro but no luck. anyone have
any ideas? Thankyou so much.
 
The simplest way is to use the DoCmd.TransferSpreadsheet method. Look in
Access help for details.

Barry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unremovable horizontal scroll bar on subform 1
Showing subform information in form (datasheet view) 1
export to excel from filtered datasheet 2
Subform question re: datasheet view 5
Can't edit record in subform datasheet view. 1
Link two subforms in datasheet view (one sub-form, one sub-subform 1
Query criteria from datasheet. 2
Highlight rows in a subform datasheet view 0

Back
Top