Re: sql statements for access tables with spaces

From: Carl G Johansson <c_joh_at_hotmail.com>
Date: Sat, 16 Sep 2000 18:43:48 GMT
Message-ID: <EbPw5.695$n4.51638@newsc.telia.net>

You must put the table name within brackets as it contains a space select * from [order details]

In my opinion a death sin to use other characters then A-Z, a-z, 0-9 in tablenames, field names etc.

Regards
-Carl

"Krusty" <danparker276_at_my-deja.com> skrev i meddelandet news:8puhoa$98l$1_at_nnrp1.deja.com...
> 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.
Received on Sat Sep 16 2000 - 13:43:48 CDT