Re: foxpro tables

I use this connection string:

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strLocalFileName
& ";Extended Properties=""FoxPro 2.6"""

My problem is that it does not work when a memo field exists. (A .fpt file.)

Have you been able to open and import a Foxpro file with a memo field?

--
Joe Fallon





"PeterK" <p.kuhne@verizon.net> wrote in message
news:%23wJ04wYPDHA.1748@TK2MSFTNGP11.phx.gbl...
> 1. connect with oledb
> 2. get the table
> 3. mydataview=thetable.defaultview
> 4. mydataview.rowfilter=" mydatacolumnname = " & thedate
> 5. scan records in the view
>
> Hope this helps
> PS As you work with foxprow tables, could you perhaps comment on my
separate
> posting (yesterday in this group). How does your VFP connection string
look
> like ?
>
> "John" <john@nospam.infovis.co.uk> wrote in message
> news:euWHJnJPDHA.1552@TK2MSFTNGP10.phx.gbl...
> > Hi
> >
> > I am using foxpro tables. I need to filter the tables on current date
> > (query?) and then sequentially go through the records. I don't have any
> > bound data controls. What data access method would be suitable for this?
> >
> > Thanks
> >
> >
>
>