Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sql.request | Excel Programming | |||
Request help | Excel Programming | |||
HELP REQUEST:Golf Scoresheet question | Excel Worksheet Functions | |||
sql.request | Excel Worksheet Functions | |||
2nd request | Excel Programming |