Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005
    Posts
    6

    Unanswered: Crosstab Query Export

    I have a crosstab query which i want to export, using a Macro, as an excel sheet to a specific folder (using TransferSpreadsheet or TransferText options in the Macro). Any ideas on how i fill in the required fields? keep getting the error "Cannot update: database or object is READ ONLY".

    I have it working perfectly for Make table queries (using TransferSpreadsheet)and it emails me the link when the macro completes. I just want to add this crosstab query to the Macro so that it also exports.
    Any help would be greatly appreciated!

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Princess

    I don't use macros - don't understand them and find they are a nightmare to debug (or whatever you call fixing a macro).

    Check out this thread - it is an alternative means of getting the data into Excel. On the second page is a template you can adapt and use. I know it works for Crosstabs because this was Blindman's requirement and I tested it before posting.

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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