How to build a SQL Stament with special chars in column names?This is a discussion on How to build a SQL Stament with special chars in column names? within the ODBC forums in Framework and Interface Programming category; Hello NG, I'm using a Ado connection to a text file. If a make "SELECT * FROM myfile.csv" I got the whole file. Now some columns have special chars like "Geburtstag 01.01.1900-31.01.1910". If I write: "SELECT Geburtstag 01.01.1900-31.01.1910 FROM myfile.csv" I got an error. The masking with brackets do also not work: "SELECT [Geburtstag 01.01.1900-31.01.1910] FROM myfile.csv". I got the error that it is not allowed to enclose a name. Any idea how to build this SQL statement? Peter... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
02-23-2006, 11:21 AM
| |||
| |||
 How to build a SQL Stament with special chars in column names? Hello NG, I'm using a Ado connection to a text file. If a make "SELECT * FROM myfile.csv" I got the whole file. Now some columns have special chars like "Geburtstag 01.01.1900-31.01.1910". If I write: "SELECT Geburtstag 01.01.1900-31.01.1910 FROM myfile.csv" I got an error. The masking with brackets do also not work: "SELECT [Geburtstag 01.01.1900-31.01.1910] FROM myfile.csv". I got the error that it is not allowed to enclose a name. Any idea how to build this SQL statement? Peter  |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -5. The time now is 06:50 AM.
