SQL Statement Failing On Windows 10

Hi vbforums,

I was not sure which thread to ask this question in. However I am using Visual Studio 2010, so perhaps a fitting spot. I have a SQL statement that was given to me on another site and this SQL statement always errors out. But I'm told it works on Windows 8.1, which I don't have access too. I thought that perhaps someone here might shed some light as to why Win 10 does not want to run it.

The SQL statement:

Code:

---

SELECT * FROM [Statement.csv] as m left join [Trans.csv] as d on m.F2=d.F1

---

The error:

Code:

---

[Microsoft][ODBC Text Driver] Too few parameters. Expected 2

---

My text driver DSN:

Code:

---

DSN=MSTextDriver;DBQ=C:\SPOOL;DefaultDir=C:\SPOOL;DriverId=27;FIL=text;MaxBufferSize=2048;PageTimeout=5;

---

My data:

• Statement.csv

Code:

---

203-010265;203-010265-08;MNR;D;WILLIAMS
203-010265;203-010265-09;MNR;D;WILLIAMS
203-010265;203-010265-17;MNR;D;WILLIAMS
203-010265;203-010265-18;MNR;D;WILLIAMS

---

• Trans.csv

Code:

---

203-010265-08;08/08/2016;62;Interest On Arrears;105.81
203-010265-08;08/08/2016;63;Monthly Service Fee;30
203-010265-09;08/08/2016;62;Interest On Arrears;185.3
203-010265-09;08/08/2016;63;Monthly Service Fee;30
203-010265-17;08/08/2016;62;Interest On Arrears;187.43
203-010265-17;08/08/2016;64;Monthly Insurance Premium;200
203-010265-17;08/08/2016;63;Monthly Service Fee;30
203-010265-18;08/08/2016;62;Interest On Arrears;96.96
203-010265-18;08/08/2016;63;Monthly Service Fee;30

---

My OS and other info:

• Windows 10 Home single language, 64 bit. Version 1607, build 14393.82.
• ODBC Data Sources (32-bit). Microsoft text driver (*.txt, *.csv). Version 10.00.10586.00. Filename ODBCJT32.DLL. Date 2015/10/30.
• Microsoft Access Database Engine 2010 Redistributable

Any help will be greatly appreciated.

Regards,
S