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 |
All times are GMT +1. The time now is 12:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com