do you have the SQL?

you can change the column name

eg: select tablex from dbtable
will return tablex as the header

while
select tablex as [X] from dbtable
will return X as the header.



"Kim Carlsen" wrote in message
...
Hi

Yes it just gives me
"Syntax error in query expression '[[ID]]'."


regards
Kim
"Patrick Molloy" wrote:

have you tried
String strSelect = "SELECT [[ID]] FROM [sheetname$]"

"Kim Carlsen" wrote in message
...
Hi

How do I do a select from a excel sheet where the column header contain
brackets? the actual name is [ID] ? I
i can't see how to escape correctly.
The code looks like:

String strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=c:\test.xlsx;Extended Properties=Excel 12.0;";
String strSelect = "SELECT [ID] FROM [sheetname$]";
OleDbDataAdapter daMaster = new OleDbDataAdapter(strSelect, strConn);

Regards
Kim