Error '' is not a valid name. Make sure that it does not include invalid characters or punctuation a

[rote]

Hello Everyone,
I'm retrieving data from Excel from my asp.net page
The WorkSheet name is StatusPasPorts.

When i remove the column [Account Reference No.] it does work fine but if i
use it i get error :
'' is not a valid name. Make sure that it does not include invalid
characters or punctuation and that it is not too long.

SELECT [Event Date],[Mobile Number],[Event Type Name],[Identification
Method],[Customer DOB],[Account Reference No.] FROM [StatusPasPorts$] where
[Mobile Number] = '" + this.TextBox1.Text.ToString() + "' order by [Event
Date] ASC

Any ideas what i'm missing.

Thanks in Advance

 

[Tim Williams]

Have you tried not using a period in the column name?

Tim

 

[Patrick.O .Ige]

Tim thanks for the reply.
But the column has a period by default.
Will have have to remove the period and save it back before using the excel?
Any worarounds for this?
Thanks

Have you tried not using a period in the column name?

Tim

Hello Everyone,
I'm retrieving data from Excel from my asp.net page
The WorkSheet name is StatusPasPorts.

When i remove the column [Account Reference No.] it does work fine but if
i use it i get error :
'' is not a valid name. Make sure that it does not include invalid
characters or punctuation and that it is not too long.

SELECT [Event Date],[Mobile Number],[Event Type Name],[Identification
Method],[Customer DOB],[Account Reference No.] FROM [StatusPasPorts$]
where [Mobile Number] = '" + this.TextBox1.Text.ToString() + "' order by
[Event Date] ASC

Any ideas what i'm missing.

Thanks in Advance