TOPIC:

I need to be able to read data from an Access table but from a starting record number.
Does FlowHeater enable me to do this?
Or do I have to read all records and then externally remove the unwanted ones?

Thanks

Hi Ken,

Of course yes FlowHeater supports more than one way to do this.

1. In case you would like to skip just the first 100 records you can use the AutoID Heater in combination with the IF-THEN-ELSE Heater for the condition and last but not least the Filter Heater to filter out the unwanted records. You´ll find a brief example attached in the ZIP archive -> filter-records-I.fhd


2. In case your Access Database Table has an Auto Increment Primary Key field you have two more option.
   First) Like above use the ID value from the Field and filter the unwanted records. You´ll find a brief example attached in the ZIP archive -> filter-records-II.fhd
   
   Second) you just use an “WHERE” in the Access Adapter READ SQL Statement like this: “select * from your_table where ID >= 100”

Note: FlowHeater supports also dynamical to export since last export only new added records. You´ll find an detailed example here: Exporting only new MySQL records to a CSV text file

Thanks Robert - that seems to have fixed things.