TOPIC: automatic import and upload csv to access mdb

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

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.