Hi Guys,

How can I write the select statement on a table name that has spaces in between? I am using an ACCESS Database

Example:

SQLString = "Select * from Look Up Table"

I am getting an error message after the word "look". I tried :

SQLString = "Select * from" & " " & "Look" & " " & "Up" & " " & "Table"

SQLString = "Select * from " & "Look " & "Up " & "Table"

I still get the same error message. The only thing I did to make it work was to rename the table to Look_Up_Table. After renaming it the program I wrote worked. I would like to find out if there is a way that I can use the program that I wrote without renaming the table name.

Thanks,
Judy

Can someone please help me

Dear judy you can use this queery

SELECT * FROM [Look Up Table]

Love 4 all

Quick answer: as qazi_nomi says, enclose the table name with brackets [ ].

Preachy answer: don't use spaces in table names, query names, report names, field names. Use either an underscore for a space or use upper/lower case to make the name readable. For example:

My_table_name
MyTableName


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division