Re: sql statements for access tables with spaces

From: spencer <spencerp_at_swbell.net>
Date: Fri, 15 Sep 2000 22:10:15 -0500
Message-ID: <LvBw5.206$mC1.108354@nnrp2.sbc.net>

use the query builder in access to build a query, then switch to the SQL view to see the actual sql statement text it generates. You may find the database table names, column names, etc. enclosed in double quotes.

"Krusty" <danparker276_at_my-deja.com> wrote in message 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 Fri Sep 15 2000 - 22:10:15 CDT