Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Euro sign in Excel column names -> Error

Status
Not open for further replies.

LaundroMat

Programmer
Dec 2, 2003
67
BE
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
Code:
$query = "SELECT * FROM [Amount in €]"
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top