import query results from multiple access files into excel

[miky011]

I have multiple MDB's files in a Windows folder named 'Results'

MDB1.MDB , MDB2.MDB , MDB3.MDB .... MDBx

These are Quotation results from vendors. Each MDB has the same Query 'Q_Total_RFQ'.

The query has three columns: "RFQ" , "Vendor" , "Total"

Now what I need is to run a script or macro that read the query from each MDB in the folder and write

it on a single Excel sheet (XLSX 2007 and above).

worksheet data should look like :

RFQ, Vendor, Total
100001, 12345, 100000
100001, 12346, 150000
100001, 12347, 95000
100001, 12348, 12000

 

[Rijnsent]

Hi Miky011,
what code did you create yourself so far?
Cheers,
Koen