Can we search column in MS access (or in Excel) table with the header which contains spaces? [modified]

[ATC]

I am able to use SQL commands to access any table & any columns in MS access (or in Excel) table. However, when I try to search columns with spaces (ie: Employee IDNumber, Employee Name, ...) then I have errors If I change to Employee_IDNumber, Employee_Name then it is OK Dim m_sModification As String = "UPDATE [Table Name$] SET Employee_Name = 'Jonny White' WHERE Employee_IDNumber = '12345678'" Dim conn1 As New System.Data.OleDb.OleDbConnection(m_sConnection1) conn1.Open() But I have the MS Access (or Excel) tables having Column Headers with spaces between, I try to avoid changing all of them with xxxxx**_**xxxxx Do we have other ways to deal with this issue? Thank in-advanced :doh:

modified on Thursday, April 3, 2008 10:34 AM

[Dave Kreskowiak]

You have to enclose and table names and columns with spaces, or names with the potential to have spaces, in square brackets ([]). Like this:

UPDATE [Table Name$] SET [Employee Name] = 'Jonny White' WHERE [Employee IDNumber] = '12345678'

But, keep in mind that having spaces in table and column names is considered bad practice. Avoid doing this if at all possible.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008

[ATC]

Hi Dave, It works! I am awared of your comments, however the existed files that has columns with spaces being done long time ago & I am not allow to remove spaces Many thanks :-D