FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Can FlowHeater read from a specified record number

Can FlowHeater read from a specified record number 1 year 7 months ago #3175

  • Ken Starnes
  • Ken Starnes's Avatar Topic Author
  • Offline
  • 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 1 year 7 months ago #3177

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

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.
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 1 year 7 months ago #3179

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

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

  • Page:
  • 1

other Languages

en
GB | US

de
DE | AT | CH

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2018 by FlowHeater GmbH. All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en