Join 2 csv files from different paths having spaces, using ACE.OLEDB.12 in Excel VBA

Didn't read it all but when text(csv) file, from close should look like

Please Login or Register  to view this content.

Hi @Jindon, sorry i am confused. Can you elaborate a working example with the above code example? i have edited the post to show you the simple csv's. I have tried various combinations, but i think i am missing the correct syntax. Secondly, there are spaces in the csv filepaths as shown in the above example e.g. 'TEST FOLDER'. These paths are originally network paths, where the 2 files lie on the same network drive, but in different folders (paths may contain spaces). How do i escape these properly?

I have also posted the same issue faced with `MICROSOFT ACCESS TEXT DRIVER` here.

I don't know if it is possible, but what is the column separator for the file?
csv usually have comma, but obviously it is not, so better upload a csv files.

They are comma delimited files. I have tried this code with other csv files also. But i have uploaded the 2 sample files for your perusal. I have only added double-quotes as text qualifiers to the sample files, as the original files have them as text-qualifiers.

I have done with multiple Excel under multiple folders, but no csv files.

This is to make it easy.
Copy the second selected file to the same folder of the first csv file, if folders are different...

Please Login or Register  to view this content.

Actually @Jindon, i cannot copy the files into same folders as these are located on our company network drive and created/updated by other teams. It would lead to confusion.

Then alternative would be copy both files to a temp folder in local then process.

Otherwise I can not help, so wait for some one to comes in.

@Jindon, I actually got it to work though getting a power query like error (listing below). See the syntax of enclosing the filepath using `back-ticks`. Also the INNER JOIN gets replaced with a "," and the ON gets replaced with a WHERE Clause.

Please Login or Register  to view this content.

While the code runs now, it generates a Power Query like Frown Error:

Please Login or Register  to view this content.

I do have some power queries defined in the workbook which reference the files. Could it be because of them? Or are you aware of such an error and its solution? I will remove the queries and their connections and try again.

Removed all power queries and connections. Still the frown error! But table gets generated. Any ideas?

I can not help you about PQ.

Some one else will give you a hand.