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"
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.
Does [url="http://mails.datawatch.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=1;t=001336#000007"]this[/url] post from Ken Indorato help at all?
The command line relates to an Excel table but as far as I know the principle is the same.