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
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