query with blank spaces in field names

[Guest]

i am trying to query a table in access from another program through SQL. My
source table has blank spaces, in the field description such as 'Equity
Style Box'. My source table is a linked table of which i do not have primary
control over. When i attempt to put brackets around this such as
tablename.[Equity Style Box], the query fails. Does anyone have any
solutions. thks

 

[Duane Hookom]

Is this a pass-through query? If so, what is the "another program"? Does
your field name actually contain two consecutive spaces or is that a typo?

 

[Guest]

Duane,

it is a select query. the query is written in this other application whereby
i can link to the access database through an OLE DB Connection- (MICROSOFT
JET OLE 4.0 DB PROVIDER). the other application is called MPI Stylus, it is
a niche financial application. No, the spaces are is as - it is not a typo.

many thanks
ken

Is this a pass-through query? If so, what is the "another program"? Does
your field name actually contain two consecutive spaces or is that a typo?

--
Duane Hookom
MS Access MVP

i am trying to query a table in access from another program through SQL. My
source table has blank spaces, in the field description such as 'Equity
Style Box'. My source table is a linked table of which i do not have
primary
control over. When i attempt to put brackets around this such as
tablename.[Equity Style Box], the query fails. Does anyone have any
solutions. thks

 

[Chris2]

it is a select query. the query is written in this other application whereby
i can link to the access database through an OLE DB Connection- (MICROSOFT
JET OLE 4.0 DB PROVIDER). the other application is called MPI Stylus, it is
a niche financial application. No, the spaces are is as - it is not a typo.

i am trying to query a table in access from another program through SQL. My
source table has blank spaces, in the field description such as 'Equity
Style Box'. My source table is a linked table of which i do not have
primary
control over. When i attempt to put brackets around this such as
tablename.[Equity Style Box], the query fails. Does anyone have any
solutions. thks

k2sarah,

1) Post the query as written in MPI Stylus (it may help, but it also
may not).

2) Are there really two spaces between Equity and Style in the
column name?

3) The query fails, but in what way? Does it return 0 rows? Is
there an error message?

MPI's website is a bit sparse on technical details (their ads go out
of its way to state that "no programming is required", <cough, cough
/>).

4) Do you have MPI Stylus' optional module Open Database Link (ODL)?

5) Does MPI Stylus come with any technical support?


Sincerely,

Chris O.