Hi Garry,

is it possible for you to edit this macro as i do not have SQL
installed or knowledge on the same ? or create please provide an new
macro in seperate file ?

SQL is not required since (as explained in the sample I linked to) each
Excel file is treated as a database and its sheets as datatables. This
tutorial teaches you how to use ADODB with Excel. If you do this kind
of work on a regular basis then you need to learn the ins-and-outs of
it. (..not meaning to offend you in any way!)

Editing your existing macro would be fruitless waste of time/energy I
don't have either of anymore (I have Lou Gehrig's). Besides, having
someone do that for you doesn't help you 'evolve' your own Excel
skills; -the only way to achieve that is by you doing the work! Better
for you to start from scratch after studying/practising the tutorial...

I might still have a sample project showing how to manage data with
arrays, but this will require opening each file to grab its data. The
ADODB approach is orders of magnitude more efficient and so why I
suggested it. Data field mapping is standard stuff and so there are
plenty of how-to VB[A] examples available online.

Alternatively, if your budget will afford you, there are several VBA
developers that you could 'contract' to develop a solution tailored to
your needs, which can be found online.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus