Exporting To Excel

  • Thread starter Thread starter JC
  • Start date Start date
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.
 
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
 
Back
Top