search all word begin "an*"

From: Christine Imbeault (imbeault.christine_at_qcmines.com)
Date: 05/25/04 

Date: Tue, 25 May 2004 15:33:17 -0400

hi,

My table is

TEST
annie
ange
mercure
anouk
test

i have a bd format DBF. i want to find all the word begin "an" in my table.
When i run the macro, the request find 0 record. My request is

Sub test()
    Dim oConn As New ADODB.Connection
    Dim orec As New ADODB.Recordset

     lcConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
               "Data Source=c:\a;" & _
              "Extended Properties=DBASE IV;"
     oConn.Open lcConnect
       lcstring = "Select * From test where test like 'an*' "
      orec.Open lcstring, oConn, 1, 2
End Sub

Thanks for help
christine

Relevant Pages

  • Re: search all word begin "an*"
    ... "Christine Imbeault" wrote in message ... > When i run the macro, the request find 0 record. ... > Sub test() ... > Dim oConn As New ADODB.Connection ...
    (microsoft.public.data.ado)
  • Re: Paste special to the active cell
    ... I wonder why you do not just put formulas underneath the input boxes ... ... this macro will do as you request:- ... Sub test() ...
    (microsoft.public.excel.programming)