LaundroMat
Programmer
Hi,
I'm accessing an Excel file through PHP, and apparently the Excel DNS Driver I'm using has a problem with the euro sign (€) in column names.
This for example
produces an error odbc_exec(): SQL error: [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect in c:\ on line 18
I've been tearing my hair out over this one, and I brought the problem down to the € sign in the column title.
Would there be any way of performing a query using a column with the € sign in it?
Thanks in advance.
I'm accessing an Excel file through PHP, and apparently the Excel DNS Driver I'm using has a problem with the euro sign (€) in column names.
This for example
Code:
$query = "SELECT * FROM [Amount in €]"
I've been tearing my hair out over this one, and I brought the problem down to the € sign in the column title.
Would there be any way of performing a query using a column with the € sign in it?
Thanks in advance.