sql.request question
 

Hi,
This is a really easy question, I just don't know what I am doing.
am using the "=sql.request" formula to import data from an acces
spreadsheet. Everything works fine until I have to import somethin
that is in a column in a microsoft access table that has a name tha
contains a space. Here is an example:
this equation works fine:

=SQL.REQUEST("DSN=MS Acces
Database;DBQ=F:\DATABASE\HSN\hsn.mdb",,,"SELECT Fax FROM ConsultantMai
WHERE (ConsultantMainID=9)")

this one does not (i have bolded the part that makes it not work)

=SQL.REQUEST("DSN=MS Acces
Database;DBQ=F:\DATABASE\HSN\hsn.mdb",,,"SELECT *Prof Limit *FRO
ConsultantMain WHERE (ConsultantMainID=9)")

The reason it does not work is because the column heading "Prof Limit
contains a space. If I change the column name to "ProfLimit" and the
input that into the equation, it works fine. However, I would rathe
not do that. Is there some way I can edit the equation to fix this?

Thanks so much!

-Stev

--
thephoenix1
-----------------------------------------------------------------------
thephoenix12's Profile: http://www.excelforum.com/member.php...fo&userid=2433
View this thread: http://www.excelforum.com/showthread.php?threadid=55931