I am trying to capture some data from a MS Access DB which was created and
populated by a VB program I did not write. I can grab all the data but I
need to grab certain columns only, problem is the column names have spaces
in them.

IE

Cabinet Height, Cabinet Depth, Cabinet Width.

When I create the SQL statement during run time I tried the following from
my C++ program

Select Cabinet Height, Cabinet Depth, Cabinet Width From tbName;

Select Cabinet_Height, Cabinet_Depth, Cabinet_Width From tbName;

Neither worked, the only thing that seems to work is the wildcard *.

Do the columns come out of the Access DB as an Array

Select column[10], column[11], column[12] From tbName;

Or is there another way to call each column from the database that I need
and not all of the columns?


Warren

"Warren" <wyght (AT) REMOVEwyght (DOT) com> wrote

"Warren" <wyght (AT) REMOVEwyght (DOT) com> wrote

Put square brackets around the column names...

Select [Cabinet Height], [Cabinet Depth], [Cabinet Width] From tbName

I recommend that people do not put any spaces or special characters in
object names.. and always put square brackets in as good practice.

--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response