Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Location
    USA
    Posts
    66

    Unanswered: Export table to Excel

    Greetings,

    Ive designed a database and deployed it without giving users access to the table. Ive also created a report for them but, their reporting needs vary time-to-time and they want to be able to manipulate the table themselves; what columns they want to include and what columns not to include (hide, unhide, sort etc.).
    I was thinking to create a button when clicked export the table in Excel format so that they can manipulate the table themselves in Excel.

    Any idea would be greatly appreciated!

    Thanks,

    OCM

  2. #2
    Join Date
    Mar 2002
    Location
    Sacramento, CA
    Posts
    120

    Try this

    DoCmd.OutputTo acTable, "yourTableName", "MicrosoftExcel(*.xls)", _
    "PATH\NameOfReport.xls", False, ""

  3. #3
    Join Date
    Sep 2002
    Location
    USA
    Posts
    66

    Export to Excel

    Thanks, it is working now.

    OCM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •