Exporting data

Resolved · Medium Priority · Version 2003

Exporting data

Hardeep has attended:
Access Intermediate course

by - delegate Hardeep [1 post] (2008 Aug 15 Fri, 16:49) Reply

Can I choose the format i export a table into excel in.

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu + 9 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	6	book now	£450	£485
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
2003	2009 Jun 4 Thu + 5 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 11 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: exporting data

by - trainer Rajeev gold contributer [462 posts] (2008 Aug 18 Mon, 11:01) Reply

Dear Hardeep

Thank you for attending Access Intermediate course. I hope you enjoyed the course and benefited from it.

If you choose Tools > Office Links > Analyze with MS Excel. It can export your table or query into Excel and then you can use the Filter options to hide or display the data.

If you only want to export few fields or records from your database then simply create a query and Tools > Office Links > Analyze with MS Excel.

I hope this has helped in answering your query!! Please mark this as resolved if it has. If not then please press the reply button and ask for further clarification!!

Many thanks

Kindest Regards

Rajeev Rawat

MOS Master Instructor 2000/2003
MCAS Master Instructor 2007