Re: sql statements for access tables with spaces

Krusty wrote:
>
> I'm trying to do sql statments from ms access tables, like that sample
> northwind database. There is a 'Order Details' table. If I go
> 'select * from Orders Details'
>
> it doesn't work, nor does 'Orders\ Details' or a bunch of other stuff
> I tried, does anyone know what I should do?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Just put the table name in brackets:

select * from [Order Details] Received on Thu Sep 21 2000 - 00:00:00 CDT