Exporting To Excel

J

JC

The company I work for has decided to keep inventory of
assets in an excel spreadsheet format. I have one dept.
that was using access to keep inventory before this
change. I am wondering if there is any way possible to
export the entire database into ONE legible spreadsheet
that would of course require some minimal editing.

Any help would be appreciated.
 
J

Jim/Chris

Create a query containing all the fields you want to export.
Then use File/Export
If you repeat this process create a macro and use the
TransferSpreadsheet action

Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top