'APPENDS DATA FROM DBF FILES (WITH THE SAME FIELD STRUCTURE) INTO ONE LARGE FILE (GOOD FOR MERGING CENSUS DATABASES)

'LOADING SCRIPTS
' 1. Double-click on an empty area on the bar containing all buttons, The "Customize" dialog appears
' 2. In the "Type" pull-down, select "View"
' 3. In the "Category" pull-down, select "Buttons", The display right below the pull down changes to show an array of buttons
' 4. Slide the scrollbar (below the button display) to the right and select the last button by clicking on it, Now click on "New"
' 5. A new blank button appears. Double-click on the blank area to the right of the entry "Click" (just below the button display)
' 6. The "Script Manager" Dialog appears, Click on "New", Enter any name in the input box that appears (prefix it with "Z_" so that it goes in the last)
' 7. A new blank script document (With the name just specified) appears. Delete whatever is on it...
' 8. Either copy-paste this ENTIRE script on the document, or, click on the button with the open-folder icon (tooltip reads "Load text file") and navigate to this file
' 9. Either done, click on the button with the tick-mark icon ("compile"). If spatial analyst is not loaded, there will be some error message, Load it
' 10. After the script is compiled (the tick-mark buton should be grayed out), close the script window and return to the view
' 11. Click on the new button to run the script

TheFiles=FileDialog.ReturnFiles({"*.DBF"},{"Database Files"},"Select files to merge",0)

ctr=0
for each f in TheFiles
  ctr=ctr+1
  if (ctr=1) then
    theBaseVtab=VTab.Make(f,TRUE,FALSE)
  else
    theappnVtab=Vtab.Make(f,FALSE,FALSE)
    theappnFlds=theappnVtab.GetFields
      for each rec in theappnVtab
        recno=theBaseVtab.AddRecord
          for each fld in theappnFlds
            val=theappnVtab.ReturnValue(fld,rec)
            theBaseVtab.SetValue(theBaseVtab.FindField(fld.GetName),recno,val)
          end
      end
  end
end

msgbox.info("Process complete","Process complete")