SQL statements

[CooterBrown]

I am importing Data from OutLook to Access. The problem is when the tables are built the record names and the table name have spaces in them. They are read only and I am unable to change the tables, records, or names. How do I write SQL statements in ASP to call a record name or a table with spaces in the name?

 

[tlbroadbent]

Enclose the name in brackets as in the following example.

Select [Normalized Subject], [Modified], [Contents]
From [Status Reports]
Where [Received]>date()-1; Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.