VBA Sql, dictionary & array Combine dbf file in access multi map drive path

[roykana]

Dear all master,
I want to merge multiple dbf file drive folders into one with access, sql and vba scripting.dictionary & array

because of thousands of data records.
the map drive that I mean is as follows :
Z:\DATA\Malfin 07\NOW\IFG.DBF
Z:\DATA\Malfin 07\NOW\GSD.DBF
Z:\DATA\Malfin 07\NOW\GPD.DBF
Z:\DATA\Malfin 07\NOW\RSD.DBF
Z:\DATA\Malfin 07\NOW\RPD.DBF
Z:\DATA\Malfin 07\NOW\GSG.DBF
Z:\DATA\Malfin 07\NOW\GPG.DBF
Z:\DATA\Malfin 07\NOW\RSG.DBF
Z:\DATA\Malfin 07\NOW\RPG.DBF
with add custom column with replace "M07"

Z:\DATA\Malfin 18\NOW\IFG.DBF
Z:\DATA\Malfin 18\NOW\GSD.DBF
Z:\DATA\Malfin 18\NOW\GPD.DBF
Z:\DATA\Malfin 18\NOW\RSD.DBF
Z:\DATA\Malfin 18\NOW\RPD.DBF
Z:\DATA\Malfin 18\NOW\GSG.DBF
Z:\DATA\Malfin 18\NOW\GPG.DBF
Z:\DATA\Malfin 18\NOW\RSG.DBF
Z:\DATA\Malfin 18\NOW\RPG.DBF
with add custom column with replace "M18"

Z:\DATA\Malfin D2\NOW\IFG.DBF
Z:\DATA\Malfin D2\NOW\GSD.DBF
Z:\DATA\Malfin D2\NOW\GPD.DBF
Z:\DATA\Malfin D2\NOW\RSD.DBF
Z:\DATA\Malfin D2\NOW\RPD.DBF
Z:\DATA\Malfin D2\NOW\GSG.DBF
Z:\DATA\Malfin D2\NOW\GPG.DBF
Z:\DATA\Malfin D2\NOW\RSG.DBF
Z:\DATA\Malfin D2\NOW\RPG.DBF
with add custom column with replace "MD2"

V:\NOW\IFG.DBF
V:\NOW\GSD.DBF
V:\NOW\GPD.DBF
V:\NOW\RSD.DBF
V:\NOW\RPD.DBF
V:\NOW\GSG.DBF
V:\NOW\GPG.DBF
V:\NOW\RSG.DBF
V:\NOW\RPG.DBF
with add custom column with replace "BOJ"


combination table names :
IFGALL
GSDALL
GSGALL
GPDALL
GPGALL
RPDALL
RPGALL
RSDALL
RSGALL


Thanks
Roykana