Re: ms access / foxpro / ole db
From: Anders Altberg (x_pragma_at_telia.com)
Date: 11/15/04
- Next message: Dan Freeman: "Re: Counting 'Many' in one-to-many realtionship"
- Previous message: Anders Altberg: "Re: Counting 'Many' in one-to-many realtionship"
- In reply to: Mike Wilson: "Re: ms access / foxpro / ole db"
- Next in thread: Rev. Mike Kujawa: "Re: ms access / foxpro / ole db"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 15 Nov 2004 16:55:20 +0100
Hi
If it's a question of view or reporting on VFP data an easy way is to make
an XML file in VFP with CURSORTOXML or tjhe XMLAdapter class, then add this
XML as the datasource of a tabel in an Access Mdgb. Open the MDB in Design
vioew, go to Filews -> Get external Data - pick XML as source type. Find the
file and that's it. VFP9 can do nested tables in XML too.
You can create a DataSourceControl object or a script and specifiy a
connectionstring of an ADODB.connection, typically
Provider=vfpoledb.1;Data
Source=H:\VFPProjcets\XXX\Data\MyDB.DBC;Password='';Mode=ReadWrite|Share
Deny ;
None;Collating Sequence=MACHINE
-Anders
"Mike Wilson" <mikewse@h_o_t_m_a_i_l.com> wrote in message
news:41907c2a$1_1@127.0.0.1...
> Ok, to sum up I interpret your answers as that there is now way of
> opening a VFP8 database into Access which will enable me to use the
> Access GUI with its table browser, query builder and other features
> to explore the database.
>
> Mike
>
> "Rick Bean" <rgbean@unrealmelange-inc.com> wrote in message
> news:%23tW1xyaxEHA.3844@TK2MSFTNGP12.phx.gbl...
> Anders,
> You are right, I guess the AutoInc field just says "Primary Key" to me,
and
> so I forget someone might actually want the AutoInc field for some other
> reason. (My only real excuse is that it's Monday morning! <g>)
>
> Rick
>
> "Anders Altberg" <x_pragma@telia.com> wrote in message
> news:uMgiOkaxEHA.3528@TK2MSFTNGP10.phx.gbl...
> > Hi Rick
> > You must be thinking of Primary Key. Even CREATE CURSOR xx (ii i
autoinc)
> > works, as well as CREATE TABLE xx FREE (ii i autoinc) , in VFP8 thst
is.
> > Cheers
> > -Anders
> >
> > "Rick Bean" <rgbean@unrealmelange-inc.com> wrote in message
> > news:#4y7brZxEHA.3336@TK2MSFTNGP11.phx.gbl...
> > Mike,
> > While I don't think you can open it through the menu, you should be open
> > it
> > through code just like any other OLE DB data source. For the appropriate
> > connection string, go to http://www.connectionstrings.com/ and go down
to
> > the Visual FoxPro, VFP OLE DB, OleDbConnection (.NET) entry.
> >
> > Note: A free table can't have an autoincrement field - it must be part
of
> > a
> > Database (.DBC).
> >
> > Rick
> >
> > "Mike Wilson" <mikewse@h_o_t_m_a_i_l.com> wrote in message
> > news:418f418f_2@127.0.0.1...
> >>I am trying to open a set of Visual Foxpro free table
> >> files (.dbf, .cdx, .fpt) in Access with no luck.
> >>
> >> I have concluded (through this post
> >>
> >
http://groups.google.se/groups?hl=sv&lr=&selm=e3JUUXCQEHA.3348%40TK2MSFTNGP09.phx.gbl)
> >> that the files are "new style" VFP 7/8
> >> files with autoincrement, and thus cannot be opened
> >> through the Visual Foxpro ODBC driver (which I have
> >> also tried).
> >>
> >> I have installed the Foxpro OLE DB provider and managed
> >> to open tables through Excel, but I cannot find a way
> >> of opening them in Access... shouldn't this be possible?
> >>
> >> Cheers / Mike
> >>
> >>
> >>
> >>
> >> ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
> > News==----
> >> http://www.newsfeeds.com The #1 Newsgroup Service in the World!
>100,000
> > Newsgroups
> >> ---= East/West-Coast Server Farms - Total Privacy via Encryption =---
> >
>
>
>
>
> ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
News==----
> http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000
Newsgroups
> ---= East/West-Coast Server Farms - Total Privacy via Encryption =---
- Next message: Dan Freeman: "Re: Counting 'Many' in one-to-many realtionship"
- Previous message: Anders Altberg: "Re: Counting 'Many' in one-to-many realtionship"
- In reply to: Mike Wilson: "Re: ms access / foxpro / ole db"
- Next in thread: Rev. Mike Kujawa: "Re: ms access / foxpro / ole db"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
