Re: sql statements for access tables with spaces

From: <sanrenkur_at_my-deja.com>
Date: Sat, 16 Sep 2000 17:46:59 GMT
Message-ID: <8q0bme$66s$1@nnrp1.deja.com>

In article <LvBw5.206$mC1.108354_at_nnrp2.sbc.net>, "spencer" <spencerp_at_swbell.net> wrote:
> 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.
> >
>
>

Hi
Change the name of the table to OrderDetails(no space). Hth
Sanrenkur

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Sep 16 2000 - 12:46:59 CDT