Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    1

    Question Unanswered: How do I use a View in the TransferSpreadsheet Action?

    In the TransferSpreadsheet Action, I would like to use a View instead of a Table Name when exporting. How do I do this? I can't use a Table Name because I'm calling information from 3 different tables. I get an error when I type the View Name. Does anyone have any experience with this?

  2. #2
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    try this:

    DoCmd.OutputTo acOutputQuery, "Your Query", acFormatXLS

    Hope this helps....

Posting Permissions

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