Our cash registers name the files that I am working with. For some reason they break the sales data into two seperate reports, which I am trying to combine together to ultimately use in a pivot table to make various reports of the data.

The first of the two reports are titled Z001*. The second one are titled Z002*.

The two digits after the underscore is the day of the month the reports were run.

An "A" is added to the end of the name of the files from the second of our two registers to save data onto the card for that day.

So..I want to combine:

[Z001_01.csv] with [Z002_01.csv] into [Sales01.csv] {....the data from register one on January 1st

[Z001_01A.csv] with [Z002_01A.csv] into [Sales01A.csv] {....the data from register two on January 1st

[Z001_02.csv] with [Z002_02.csv] into [Sales02.csv] {....the data from register one on January 2nd

[Z001_02A.csv] with [Z002_02A.csv] into [Sales02A.csv] {....the data from register two on January 2nd

[Z001_03.csv] with [Z002_03.csv] into [Sales03.csv] ................

[Z001_03A.csv] with [Z002_03A.csv] into [Sales03A.csv]

[Z001_04.csv] with [Z002_04.csv] into [Sales04.csv]

[Z001_04A.csv] with [Z002_04A.csv] into [Sales04A.csv]

[Z001_05.csv] with [Z002_05.csv] into [Sales05.csv]

[Z001_05A.csv] with [Z002_05A.csv] into [Sales05A.csv]

[Z001_06.csv] with [Z002_06.csv] into [Sales06.csv]

[Z001_06A.csv] with [Z002_06A.csv] into [Sales06A.csv]

[Z001_07.csv] with [Z002_07.csv] into [Sales07.csv]

[Z001_07A.csv] with [Z002_07A.csv] into [Sales07A.csv]

[Z001_08.csv] with [Z002_08.csv] into [Sales08.csv]

[Z001_08A.csv] with [Z002_08A.csv] into [Sales08A.csv]

[Z001_09.csv] with [Z002_09.csv] into [Sales09.csv]

[Z001_09A.csv] with [Z002_09A.csv] into [Sales09A.csv]

[Z001_10.csv] with [Z002_10.csv] into [Sales10.csv]

[Z001_10A.csv] with [Z002_10A.csv] into [Sales10A.csv]

[Z001_11.csv] with [Z002_11.csv] into [Sales11.csv]

[Z001_11A.csv] with [Z002_11A.csv] into [Sales11A.csv]

[Z001_12.csv] with [Z002_12.csv] into [Sales12.csv]

[Z001_12A.csv] with [Z002_12A.csv] into [Sales12A.csv]

[Z001_13.csv] with [Z002_13.csv] into [Sales13.csv]

[Z001_13A.csv] with [Z002_13A.csv] into [Sales13A.csv]

[Z001_14.csv] with [Z002_14.csv] into [Sales14.csv]

[Z001_14A.csv] with [Z002_14A.csv] into [Sales14A.csv]

[Z001_15.csv] with [Z002_15.csv] into [Sales15.csv]

[Z001_15A.csv] with [Z002_15A.csv] into [Sales15A.csv]

[Z001_16.csv] with [Z002_16.csv] into [Sales16.csv]

[Z001_16A.csv] with [Z002_16A.csv] into [Sales16A.csv]

[Z001_17.csv] with [Z002_17.csv] into [Sales17.csv]

[Z001_17A.csv] with [Z002_17A.csv] into [Sales17A.csv]

[Z001_18.csv] with [Z002_18.csv] into [Sales18.csv]

[Z001_18A.csv] with [Z002_18A.csv] into [Sales18A.csv]

[Z001_19.csv] with [Z002_19.csv] into [Sales19.csv]

[Z001_19A.csv] with [Z002_19A.csv] into [Sales19A.csv]

[Z001_20.csv] with [Z002_20.csv] into [Sales20.csv]

[Z001_20A.csv] with [Z002_20A.csv] into [Sales20A.csv]

[Z001_21.csv] with [Z002_21.csv] into [Sales21.csv]

[Z001_21A.csv] with [Z002_21A.csv] into [Sales21A.csv]

[Z001_22.csv] with [Z002_22.csv] into [Sales22.csv]

[Z001_22A.csv] with [Z002_22A.csv] into [Sales22A.csv]

[Z001_23.csv] with [Z002_23.csv] into [Sales23.csv]

[Z001_23A.csv] with [Z002_23A.csv] into [Sales23A.csv]

[Z001_24.csv] with [Z002_24.csv] into [Sales24.csv]

[Z001_24A.csv] with [Z002_24A.csv] into [Sales24A.csv]

[Z001_25.csv] with [Z002_25.csv] into [Sales25.csv]

[Z001_25A.csv] with [Z002_25A.csv] into [Sales25A.csv]

[Z001_26.csv] with [Z002_26.csv] into [Sales26.csv]

[Z001_26A.csv] with [Z002_26A.csv] into [Sales26A.csv]

[Z001_27.csv] with [Z002_27.csv] into [Sales27.csv]

[Z001_27A.csv] with [Z002_27A.csv] into [Sales27A.csv]

[Z001_28.csv] with [Z002_28.csv] into [Sales28.csv]

[Z001_28A.csv] with [Z002_28A.csv] into [Sales28A.csv]

[Z001_29.csv] with [Z002_29.csv] into [Sales29.csv]

[Z001_29A.csv] with [Z002_29A.csv] into [Sales29A.csv]

[Z001_30.csv] with [Z002_30.csv] into [Sales30.csv]

[Z001_30A.csv] with [Z002_30A.csv] into [Sales30A.csv]

[Z001_31.csv] with [Z002_31.csv] into [Sales31.csv]

[Z001_31A.csv] with [Z002_31A.csv] into [Sales31A.csv]

Each of the Z001 reports contains data similar to the following:

MODEL#,TE-2200

MACHINE#,MC#01

REPORT #,FIX

FILE #,FILE001

MODE #,Z

Z COUNTER #,1430

DATE #,1/2/2013

TIME #,8:19 PM

GROSS #,314

GROSS $,1044.51

NET #,87

NET $,951.52

CAID #,0

CAID $,455.4

CATL #,0

CATL $,0

CA- #,0

CA- $,0

CA+ #,0

CA+ $,0

CHID #,0

CHID $,0

CHTL #,0

CHTL $,0

CH- #,0

CH- $,0

CH+ #,0

CH+ $,0

CKID #,0

CKID $,45.15

CKTL #,0

CKTL $,0

CK- #,0

CK- $,0

CK+ #,0

CK+ $,0

CRID(1) #,0

CRID(1) $,677.57

CRID(2) #,0

CRID(2) $,0

CRID(3) #,0

CRID(3) $,0

CRID(4) #,0

CRID(4) $,0

CRTL #,0

CRTL $,0

CR- #,0

CR- $,0

CR+ #,0

CR+ $,0

CAID2 #,0

CAID2 $,0

CATL2 #,0

CATL2 $,0

CA- 2 #,0

CA- 2 $,0

CA+ 2 #,0

CA+ 2 $,0

CHID2 #,0

CHID2 $,0

CHTL2 #,0

CHTL2 $,0

CH- 2 #,0

CH- 2 $,0

CH+ 2 #,0

CH+ 2 $,0

CKID2 #,0

CKID2 $,0

CKTL2 #,0

CKTL2 $,0

CK- 2 #,0

CK- 2 $,0

CK+ 2 #,0

CK+ 2 $,0

CRID2(1) #,0

CRID2(1) $,0

CRID2(2) #,0

CRID2(2) $,0

CRID2(3) #,0

CRID2(3) $,0

CRID2(4) #,0

CRID2(4) $,0

CRTL2 #,0

CRTL2 $,0

CR- 2 #,0

CR- 2 $,0

CR+ 2 #,0

CR+ 2 $,0

FSID #,0

FSID $,0

FSCACG #,0

FSCACG $,0

EBTTL #,0

EBTTL $,0

EBTCACG #,0

EBTCACG $,0

RF #,0

RF $,0

CUST #,87

CUST $,0

AVRG #,0

AVRG $,0

FEE #,0

FEE $,0

+ #,0

+ $,0

NB #,0

NB $,0

C-1 #,0

C-1 $,0

C-2 #,0

C-2 $,0

CECA1 #,0

CECA1 $,0

CECK1 #,0

CECK1 $,0

CECA2 #,0

CECA2 $,0

CECK2 #,0

CECK2 $,0

CECA3 #,0

CECA3 $,0

CECK3 #,0

CECK3 $,0

CECA4 #,0

CECA4 $,0

CECK4 #,0

CECK4 $,0

DC #,0

DC $,139.46

COUPON #,0

COUPON $,0

REF #,0

REF $,0

CLEAR #,0

CLEAR $,0

ROUND #,0

ROUND $,0

ROUND #,0

ROUND $,0

CANCEL #,3

CANCEL $,9.47

DECLA #,0

DECLA $,0

TA1 #,0

TA1 $,120.73

TX1 #,0

TX1 $,0

EX1 #,0

EX1 $,0

TA2 #,0

TA2 $,652.64

TX2 #,0

TX2 $,46.47

EX2 #,0

EX2 $,0

TA3 #,0

TA3 $,0

TX3 #,0

TX3 $,0

EX3 #,0

EX3 $,0

TA4 #,0

TA4 $,0

TX4 #,0

TX4 $,0

EX4 #,0

EX4 $,0

TA5 #,0

TA5 $,0

TX5 #,0

TX5 $,0

EX5 #,0

EX5 $,0

TA6 #,0

TA6 $,0

TX6 #,0

TX6 $,0

EX6 #,0

EX6 $,0

TA7 #,0

TA7 $,0

TX7 #,0

TX7 $,0

EX7 #,0

EX7 $,0

TA8 #,0

TA8 $,0

TX8 #,0

TX8 $,0

EX8 #,0

EX8 $,0

TA9 #,0

TA9 $,0

TX9 #,0

TX9 $,0

EX9 #,0

EX9 $,0

TA10 #,0

TA10 $,0

TX10 #,0

TX10 $,0

EX10 #,0

EX10 $,0

NON TAX #,0

NON TAX $,146.47

Each of the Z001 reports contains data similar to the following:

CASH #,56

CASH $,228.8

TRES.CARD #,6

TRES.CARD $,45.15

CREDIT2 #,0

CREDIT2 $,0

HELP #,0

HELP $,0

SUBTOTAL #,0

SUBTOTAL $,0

CHARGE #,0

CHARGE $,0

CREDIT #,26

CREDIT $,677.57

PD #,0

PD $,0

LOAN #,1

LOAN $,226.6

P.UP #,0

P.UP $,0

T/S2 #,0

T/S2 $,0

T/S1 #,0

T/S1 $,0

. #,0

. $,0

CLK# #,0

CLK# $,0

0 #,0

0 $,0

QT #,0

QT $,0

CORR #,3

CORR $,9.47

PLU# #,0

PLU# $,0

PRC #,0

PRC $,0

#/NS #,5

#/NS $,0

CE #,0

CE $,0

RF #,0

RF $,0

- #,0

- $,0

%- #,26

%- $,75.98

%- #,31

%- $,63.48

RCT ON/OFF #,0

RCT ON/OFF $,0

Eventually I will turn the data horizontal so that the data from each register for each day forms a row. I assume it is easier to combine the two reports row than as columns.

I don't have any experience with Access. I guess I have assumed that I would work with Excel to create the reports. I dunno????

Is is significantly faster and more efficient to combine the files in Excel that in Word?