sql.request question

T

thephoenix12

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top