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 Mike Lewis 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
0
0
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