TOPIC: two or more linked tables in Access (write side)

@echo off
REM adapt the following to the actual path of FHBatch.exe
set FHBATCH="C:\Program Files\FlowHeater V2\BIN\FHBatch.exe"

%FHBATCH% import-master-table.fhd
%FHBATCH% import-detail-table.fhd
REM … and so on

// NOTE! to use this script you have to switch the "Execute when" option to "Start"
public object DoWork()
{
  // get access to the read/write TextFile adapters
  TextFileAdapter read = (TextFileAdapter)AdapterRead;
  TextFileAdapter write = (TextFileAdapter)AdapterWrite;


  // obtain the read file name, extract directory and file name without extension
  string directory = Path.GetDirectoryName(read.Filename);
  string filename  = Path.GetFileNameWithoutExtension(read.Filename);


  // set new write file name with new extension for next step!
  write.Filename = Path.Combine(directory, filename + ".step1");


  // just return null
  return null;
}

@echo off
REM adapt the following to the actual path of FHBatch.exe
set FHBATCH="C:\Program Files\FlowHeater V2\BIN\FHBatch.exe"

%FHBATCH% /ReadFileName *.step1 transform-1.fhd
%FHBATCH% /ReadFileName *.step2 transform-2.fhd
%FHBATCH% /ReadFileName *.step3 transform-3.fhd