1 Reply Latest reply: May 15, 2014 9:57 AM by Grant Perkins RSS

    Export To Access w/o overwriting existing table

    Ricardo _

      Does anyone one know how to write a bat file which allows to export to access without overwriting the existing table.  I want to add an additional table(named differenlty). I have been able to get it to export the table however it keeps overwriting the existing table.  Here is my script so far:

      "C:Program FilesMonarchProgramMonarch.exe" "G:WindowsDcharges" "G:OPSModelsqb rr late charges daily.xmod" "O:Revenue CycleCharges.mdb" "/exptableopt:append"

      "/exptable:test1"

       

      I have inverted the last two commands and this still overwrites the table even though they are named differently.  Any help would be appreciated greatly.