You have indeed clearly explained the part of the process where you do not have a problem. Unfortunately, the part where you are asking for help is still unclear to me.

Are you asking for help to "get these files into Access"? If so, you'll need to provide details on the Access schema so that somebody with Access knowledge can help.

How can the data be modified in Access but "not changed by the manipulation in Access"?

Is the data coming out of Access to be merged or are you just merging the original output files you already have?

Have you tried to append all the files and remove the delimiters using my instructions in a previous post? Here's an even clearer sample:

  perl -e 's/,//g' inputfile1 inputfile2 >outputfile
[download]

-- Eric Hammond