Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

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 05:18PM

#1

lukin

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

Join Date: February 2002

Posts: 3841

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 07: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 08: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