'' is not a valid name. Make sure that it does not include invalid

• Patrick.I

  Hall of Fame

  Points: 3105

  More actions

  January 22, 2008 at 9:48 pm

  #75841

  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

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  January 22, 2008 at 10:05 pm

  #770738

  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

  Try with the above. You are putting . after Account Reference No. I hope it should work out.

• Patrick.I

  Hall of Fame

  Points: 3105

  More actions

  January 22, 2008 at 11:06 pm

  #770747

  Thanks but thats whats in the colum name in Excel

  Its with a dot [Account Reference No.]

  Any work around?