Handling special characters in column names in excel

Hi,

We are using oleDb to write data to excel work***. When creating
columns we are not having any problems with special characters, the
following statement executes fine.

command.CommandText = "CREATE TABLE Apples ([Fruit Paste 1.1 (Apple)]
char(255))";

while inserting a value, the below line is throwing an exception and
it is because of this 1.1..

command.CommandText = "INSERT INTO [Apples$](Fruit Paste 1.1 (Apple))
VALUES("1")"

Are there any alternative ways to get this to work..I did not find
much documentation on this.

Thanks in advance,

.

Loading