Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
exporting data

ResolvedVersion 2003

Hardeep has attended:
Access Intermediate course

Exporting data

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

RE: exporting data

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.