| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO syntax problem
strCellCode = rst.Fields("Cell").Value
Tim "???" wrote in message ... Hi! I am using the following code to query access table. the code works fine. My problem is how to name the field name ([Cell]) as a string, in order to use this query as a dynamic query. I tried many things but nothing succeeded. Thanks for your help! Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\Documents and Settings\Eli\My Documents\ETV_Cells.mdb" rst.Open "SELECT * FROM CellTable ;", cnn, adOpenStatic rst.MoveFirst strCellCode = rst![Cell] rst.Close cnn.Close Set rst = Nothing Set cnn = Nothing Eli |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DAO Syntax Problem | Excel Programming | |||
| Syntax problem | Excel Programming | |||
| Syntax problem | Excel Worksheet Functions | |||
| Another Syntax Problem | Excel Programming | |||
![Tim Williams[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
