acces 97: export multiple queries into one workbook

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • JMCN
    #1

    acces 97: export multiple queries into one workbook

    is it possible to export multiple queries into one workbook, having
    each query as separate worksheet? i cannot specify a range because the
    records will change on a daily basis as for query size.
    i tried the following transferspreads heet method but the database
    could not find 'TFM$' because it was not a valid parameter.

    DoCmd.TransferS preadsheet acExport, 8, "TFM",
    "C:\Temp\NonCri tical.xls", True, "'TFM'!"
    DoCmd.TransferS preadsheet acExport, 8, "STRUCTURED ",
    "C:\Temp\NonCri tical.xls", True, "'STRUCTURE D'!"
    DoCmd.TransferS preadsheet acExport, 8, "NRT",
    "C:\Temp\NonCri tical.xls", True, "'NRT'!"

    thanks in advance
    jung
    Tags: None
    • Herbert Chan
      #2
      Re: acces 97: export multiple queries into one workbook

      I'm also doing this in one of my Access project.

      Maybe you can just omit the last parameter from your codes, i.e., "TFM'!'",
      "'STRUCTURED'!' ", "'NRT'!". I don't think these are necessary. The
      worksheets will have names the same as the queries that are being exported.

      Herbert

      "JMCN" <picarama@yahoo .fr> ¦b¶l¥ó
      news:2772ee20.0 404091310.3637a c3@posting.goog le.com ¤¤¼¶¼g...[color=blue]
      > is it possible to export multiple queries into one workbook, having
      > each query as separate worksheet? i cannot specify a range because the
      > records will change on a daily basis as for query size.
      > i tried the following transferspreads heet method but the database
      > could not find 'TFM$' because it was not a valid parameter.
      >
      > DoCmd.TransferS preadsheet acExport, 8, "TFM",
      > "C:\Temp\NonCri tical.xls", True, "'TFM'!"
      > DoCmd.TransferS preadsheet acExport, 8, "STRUCTURED ",
      > "C:\Temp\NonCri tical.xls", True, "'STRUCTURE D'!"
      > DoCmd.TransferS preadsheet acExport, 8, "NRT",
      > "C:\Temp\NonCri tical.xls", True, "'NRT'!"
      >
      > thanks in advance
      > jung[/color]


        Comment

        • JMCN
          #3
          Re: acces 97: export multiple queries into one workbook

          "Herbert Chan" <herbert@chan.c om> wrote in message news:<40776d33$ 1_2@rain.i-cable.com>...[color=blue]
          > I'm also doing this in one of my Access project.
          >
          > Maybe you can just omit the last parameter from your codes, i.e., "TFM'!'",
          > "'STRUCTURED'!' ", "'NRT'!". I don't think these are necessary. The
          > worksheets will have names the same as the queries that are being exported.
          >
          > Herbert
          >[/color]


          thanks herber! you are totally correct! for some reason i thought i
          needed to indicate the name of the worksheet even if i did not have a
          range.
          thanks again! cheers - jung

            Comment

            Previous template Next
            Working...