Exporting from Access to Excel

lukin · 2009-10-05 16:18:08

Is there more to exporting data from Access to Excel than just right-clicking on a table, form or report and selecting "Export"? I have been asked to export some data from an Access db to Excel and I have never done it before. Is there some "hidden" stuff I should know?

05-10-2009 04:18PM

#1

lukin

Registered Users, Registered Users 2 Posts: 4,351 ✭✭✭

Join Date: February 2002

Posts: 3864

Is there more to exporting data from Access to Excel than just right-clicking on a table, form or report and selecting "Export"?
I have been asked to export some data from an Access db to Excel and I have never done it before. Is there some "hidden" stuff I should know?

0

Comments

#2 05-10-2009 06:47PM

bothyhead

Registered Users, Registered Users 2 Posts: 442 ✭✭

Join Date: July 2008

Posts: 400

Nope that's it. You will have to export each table separately, and each will get exported into their own .XLS file. Once you do this, the XLS file is totally separated from the MDB file: changing data in one will not affect the other.

0
#3 05-10-2009 07:57PM

FSL

Registered Users, Registered Users 2 Posts: 1,456 ✭✭✭

Join Date: February 2006

Posts: 1419

You can link a range or pivot table in an Excel spread sheet to a table or query in an Access database. Once the link is established it can be refreshed on demand.

0