Re: Access mdb file
- From: "tom knauf" <hbgmail@xxxxxxxxxx>
- Date: Mon, 18 Jul 2005 10:00:50 +0200
Hi,
if you just want to read from access (and know/ask user for the tablename)
we use code like this :
cFile = "d:\Daten.mdb"
cconn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" + cFile +
";Exclusive=1;Uid=admin;Pwd="
nConn=SQLSTRINGCONNECT(cConn)
IF nCOnn>0
nerg = SQLEXEC(nCOnn,'Select * from table1','dummy2')
if nerg>0 && Now data is in cursor dummy2
SELECT dummy2
browse && or so
endif
SQLDISCONNECT(nConn)
ENDIF
CLOSE DATABASES
You do NOT need a sqlserver or msde, just installed acces or installed
access odbc drivers.
HTH
Tom
"Jan" <nomail@xxxxxxxxxxx> schrieb im Newsbeitrag
news:uyoDTfdiFHA.3336@xxxxxxxxxxxxxxxxxxxxxxx
> Hi all,
>
> I have a small app that does some reporting from legacy dbf files. The app
> that created the dbf files has been migrated to a windows app and now
> produces mdb files. What do I need to access mdb files from vfp? I would
> like to add this as an option to my existing reporting app so that the
user
> can choose from their older files or their newer ones to produce the
report.
>
> Some sample code would be useful as would a pointer to the available
syntax
> to do this.
>
> TIA
> Jan
>
>
.
- References:
- Access mdb file
- From: Jan
- Access mdb file
- Prev by Date: Re: "Class is not licensed for use"
- Next by Date: SV: SV: views and indexes
- Previous by thread: SV: Access mdb file
- Next by thread: Re: Access mdb file
- Index(es):
Relevant Pages
|
Loading
