Join 2 csv files in different paths having spaces, with ODBC MICROSOFT ACCESS TEXT DRIVER

I am using Windows 10 Enterprise 64-bit and Excel 2016 64-bit. The following code uses ODBC `MICROSOFT ACCESS TEXT DRIVER` and works fine if there are no spaces in the different file paths. It fails with a `Syntax in FROM Clause error` if there are spaces in the file paths. I have tried 'single-quotes', "double-quotes", [square-brackets], `apostrophes`, Chr(34) etc., but still getting the same Syntax error. Can anyone help me understand what is the correct syntax?

Please Login or Register  to view this content.

I finally got it to work and was also able to resolve the power query FROWN Error issue (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.

Listing the steps i took:

1. Removed all Power Queries in Excel workbook.
2. Installed latest Office 2016 Sept 3 updates from the following MS site.
3. Rebooted my System.

The 2nd AND / OR the 3rd point may have resolved the issue, as i cannot see it is documented on MS site (my trial & error).

For those who may face the same issue, the SQL QUERY SYNTAX is as shown in the above code. I was also able to use this same SYNTAX with ACE.OLEDB.12 Driver and it works fast and fine in both cases.

Please Login or Register  to view this content.