Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

automatic import and upload csv to access mdb

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
9 years 10 months ago #2327 by FlowHeater-Team
automatic import and upload csv to access mdb was created by FlowHeater-Team
I get every day 5 csv files at fix time which I need to convert to mdb file.

My steps are :
  1. extract them.
  2. Convert to 5 mdb tables (can I schedule the convert with your program?)
  3. Upload the new db into my webserver.

Which steps you can help me with?

Another question, I see that you have more facilities can I change some fileds before I will put them on the db ?

i.e.
csv file : A;DSL;TSO;RC1;2014-09-01;O;1

mdb file should be
: A;DSL;TSO;RC1;2014-09-01;R;1

I have fix rule for that. If DSL;TSO then change to R

Today I work with your program like that:
I make 5 definitions 1 for each table then each day I open each definition and connect it to the new csv table.

I would appreciate your help
Avishay
Request received via email

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.

Please Log in to join the conversation.

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
9 years 10 months ago - 9 years 10 months ago #2328 by FlowHeater-Team
Replied by FlowHeater-Team on topic automatic import and upload csv to access mdb
Hi Avishay,

You could automate and schedule all these steps with just one batch CMD script and the Windows Task Scheduler. You find an example how to implement here: Automated batch CSV import into MS Access

You need for each different CSV file and Access table one FlowHeater definition with our rules for this file.

Then you have to create one CMD script for your needed steps. I’ve made a short example please have a look to the file “automatic-import.cmd” in the attached archive.
The CMD Script works like
  1. Define where the FHBatch.exe and the WinSCP.exe can be found
  2. Import 1-n CSV files with the Batch Module to your Access mdb tables. In the script wildcards are used for each file.
  3. Upload the new Access mdb file to your web server. For uploading I’ve used WinSCP with command line parameters. WinSCP is free, more details can be found here: http://winscp.net/eng/docs/commandline

Manipulate content before importing) That’s the power of FlowHeater. In the example I use the String Replace Heater together with the String Append Heater to implement your rule.


File Attachment:

File Name: automatic-...cess.zip
File Size:17 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:
Last edit: 9 years 10 months ago by FlowHeater-Team.

Please Log in to join the conversation.

Time to create page: 0.290 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

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