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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rote - 23 Jan 2008 04:22 GMT

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

Reply to this Message

Tim Williams - 23 Jan 2008 05:40 GMT

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
[quoted text clipped - 13 lines]
>
> Thanks in Advance

Reply to this Message

Patrick.O .Ige - 23 Jan 2008 12:35 GMT

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?
>
[quoted text clipped - 17 lines]
> >
> > Thanks in Advance

Reply to this Message