update needed in a macro

[nicoboss]

Hi,



I use an access file to upload csv files.
Here is the app : https://www.accessforums.net/attachm...0&d=1529335018
I have attached one example of csv file it uploads. csvexample.zip

I would like to update this application.

The general concept remains the same but instead of creating 1 mdb destination file, I would like the app to create 10 different mdb destination files and dispatch the lines from the csv depending on the content of the line.

So the access application should :
1. create 10 smaller files with the same name as the original csv file and the suffix "-1", "-2", "-3", "-4", ... "-10" at the end. If one of these small files already exist in the folder, the data should be added into this already existing file.
2. depending on the 8 first characters (generally composed of 2 letters, 1 space, 2 letters, 1 space, 2 letters) of the 1st field, each line should be dispatch into 1 of these 10 smaller files. I provide the table of correspondance (https://www.accessforums.net/attachm...9&d=1530105590) which relates every sequence of 8 characters with the small file number. One specific line whose ID field contain "Flop_Tur" should be added to all 10 small files, except if this line is already in the small file in order to avoid duplicates.

Thank you for helping me !

Nico

[June7]

Modify code to use conditional statements. Use If Then Else or Select Case structures.

[nicoboss]

Modify code to use conditional statements. Use If Then Else or Select Case structures.

Hi June7,

Sorry, I don't know coding so I don't know how to do that.