Posted by Chung Leong on 05/10/07 16:28

On May 9, 5:33 pm, dkirkd...@yahoo.com wrote:
> I am having a problem getting results back from a SELECT statement
> using the script below. The field names contain decimals and I am not
> sure wether or not this is causing the problem or not?? I am
> connecting to a SQL server db using ODBC, first time connecting to SQL
> server but have been using ODBC to connect to Access db's for years. I
> have entered the field names just as they are in the table and I have
> tried replacing the spaces and decimals with underscores but still
> recieve the same error. Anyway, my simple script and the error that I
> am recieveing is below. Any help would be greatly appreciated..

You need square brackets around the table name if it contains special
characters.

[Back to original message]