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: Import CSV files automatically into MS SQL Server

Import CSV files automatically into MS SQL Server 3 years 4 months ago #2291

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Administrator
  • Administrator
  • Posts: 254
I tried your free demo software and we like it.

We have tons of data belongs to gas stations sales needs to be converted to MS SQL Server tables but we face a lot of problems.
Your software solves most of the issues but we need more information about your designer version. Can we make an executable files that runs always and export the data to our SQL table automatically .

Best Regards,
S. Dabbagh
Support request received via email

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.

Import CSV files automatically into MS SQL Server 3 years 4 months ago #2292

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Administrator
  • Administrator
  • Posts: 254
For this you need the power of the Batch Module. With the Batch Module it is possible to run every with the FlowHeater Designer created import definition automatically.

For example) FHBatch.exe Your-CSV-Import-Defintion.fhd

You could run import/export definitions either with a link (shortcut) on your desktop and a double click on it or automated and unattended from a scheduled Windows task.

Please have a look to the follows
Batch Module (online help)
Automated batch CSV import into MS Access

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.
Last Edit: by FlowHeater-Team.
  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.081 seconds