Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Could some one please help me to interpret the following syntax
I am asked to reprogram a Excel/VBA program, and need help
regarding the following code which querying an Access Database on the server: Set Conn = CreateObject("ADODB.Connection") Conn.Open strADOName strSQL = "SELECT JobNo FROM tblPourItem" strSQL = strSQL & " WHERE JobNo = '" & strJobNo & "'" Could someone please direct me to a source where I could get information relating to querying external DataBase, like in the above example, what's the function of SELECT? Especially this line: strSQL = strSQL & " WHERE JobNo = '" & strJobNo & "'" WHat is the purpose of ' ? Also, is there a function in ADO that would let me retrieve the file's path? Cause I need to find out the date last modified to Conn(in the example, which is located on the sever). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine and interpret the P-Value | Excel Discussion (Misc queries) | |||
How do I interpret the result of a chitest? | Excel Discussion (Misc queries) | |||
How do I create and interpret a river diagram? | Charts and Charting in Excel | |||
How do I interpret a stock chart ? | Excel Discussion (Misc queries) | |||
Why does Excel interpret 2/29 as Feb 1st? | Excel Discussion (Misc queries) |