Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Connection
When performing a SELECT how do I tell my tables are located in different
paths? I'm doing: rCON.Open sSQL_C, cnn, , adCmdText. where cnn="cnn.Open "driver={Microsoft dBase Driver (*.dbf)};" & _ "driverid=277;dbq=c:\VB\CBS" sSQL_C="SELECT TABLE1.field1,TABLE1.field2,TABLE2.field1,TABLE2.f ield2 FROM TABLE1,TABLE2 WHERE TABLE1.field1=TABLE2.field1 AND ((TABLE1.field1 like 'YL%'))" TABLE1 is located in c:\VB\CBS TABLE2 is located in c:\VB\CBS\NP Any clue? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I save a workbook(2007) w/ a data connection to htm no data? | Excel Discussion (Misc queries) | |||
Data Connection | Excel Discussion (Misc queries) | |||
Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
always recheck data connection library in MOSS for latest data sou | Excel Discussion (Misc queries) |