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

export excel

ResolvedVersion 2003

Tom has attended:
Access Intermediate course
Access Introduction course

Export to Excel

How do you export the datasheet to excel

RE: Export to Excel

Dear Tom

Thank you for attending Access Courses. I hope you enojyed the coures and benefited from them.

Exporting table or query is quite simple.

Open the table or the qurey (in Datasheet View) that you want to export to Excel.

Choose Tools > Office Links >
Analyze it with Microsoft Office Excel.

Then save the exacel file with a new name.

I hope this helps in answering your query.

Please mark this post as resolved.

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.