Dynamic data import / export

datenbank

simply more productive
Up to 100,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.
  • Page:
  • 1

TOPIC: Can FlowHeater read from a specified record number

Can FlowHeater read from a specified record number 3 months 4 weeks ago #3175

  • Ken Starnes
  • Ken Starnes's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 8
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

Please Log in or Create an account to join the conversation.

Can FlowHeater read from a specified record number 3 months 3 weeks ago #3177

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 268
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


File Attachment:

File Name: filter-records.zip
File Size: 4 KB
Attachments:

Please Log in or Create an account to join the conversation.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Can FlowHeater read from a specified record number 3 months 3 weeks ago #3179

  • Ken Starnes
  • Ken Starnes's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 8
Thanks Robert - that seems to have fixed things.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.087 seconds