1 Reply Latest reply: May 15, 2014 9:56 AM by DY*BIM _ RSS

    Monarch Append Table Exports Using VBA

    MorseB _

      I do not understand how to write the VBA code for appending table exports to one Microsoft Access database table.

       

      Can anyone help?

       

      Thanks.

        • Monarch Append Table Exports Using VBA
          DY*BIM _

          I am not sure what part of the code you need, but the following syntax is for the append:

           

          blnExport = objMonarch.JetExportTable(FileName, TableName, 2)

           

          Where the 2 indicates append.   (0 = overwrite; 1 = new).

           

          Check the programmer's guide, Chapter 2 Page 9

           

          HTH,

           

          dy

           

          [size="1"][ August 30, 2004, 07:36 PM: Message edited by: DY*BIM ][/size]