Clipper - Access to dbf

Author

Access to dbf

Stephan Koenig

2005-05-17, 8:55 pm

In order to make phone numbers more accurate I found the official Nanpa
Database at

http://www.nanpa.com/npa/allnpas.zip

It is an access file.

Once a month I want to download the database and convert it to a text file
or a dbf.

Unfortunately I have never used access and no idea how to do that. does
anybody know a small tool ? I want to do that automated. Any big commercial
tool would be a complete overkill.

I work with clipper an xpp.

Thank you so much for your help !

Stephan

AUGE_OHR

2005-05-18, 3:55 am

hi,

>
> Thanks Rob. I just guess that can not be automated.

if you use xpp v1.9.317, you can use "ActiveX" to read it into Excel and
save it as DBF

.... don´t ask for ready working sample yet :)

greetings by OHR
Jimmy

sali

2005-05-18, 3:55 am

"John F. Eldredge" <john@jfeldredge.com> wrote in message
news:1kja811l88cdmqdk9qkteeq37gfhh3mev3@
4ax.com...
> On Fri, 13 May 2005 18:59:37 -0400, Joe Wright
> <joewwright@comcast.net> wrote:
>
>
> Rather than trying to figure out the format of the Access MDB file, I
> would recommend using Microsoft's ADO library (part of MDAC) to read
> the contents of the database.
>

i prefer vbscript solution.
it is extremely easy to integrate with access and dbase, and has clear logic
and you may
put vbscript code into task schedular for automatic execution.

for general data management you need ado, for acces you need [built in]
access driver, for dbase
you may use either vfoxpro ole db driver or or xscript dbf com object.

the whole thing is not more complicated than copying one database to another
within clipper code.

sali

2005-05-20, 3:55 pm

John F. Eldredge

2005-05-20, 3:55 pm

On Sun, 15 May 2005 22:26:27 +0100, "sali" <sali@tel.net.ba> wrote:

>"John F. Eldredge" <john@jfeldredge.com> wrote in message
> news:1kja811l88cdmqdk9qkteeq37gfhh3mev3@
4ax.com...
>
>i prefer vbscript solution.
>it is extremely easy to integrate with access and dbase, and has clear logic
>and you may
>put vbscript code into task schedular for automatic execution.
>
>for general data management you need ado, for acces you need [built in]
>access driver, for dbase
>you may use either vfoxpro ole db driver or or xscript dbf com object.
>
>the whole thing is not more complicated than copying one database to another
>within clipper code.

My point, however, is that it is easier to use a driver to retrieve
and manipulate the contents of the Access database, rather than trying
to reverse-engineer it, regardless of what language you are working
in. The internal structure of Access databases isn't publicly
documented anywhere that I know of, and is presumably complex, given
that it can contain forms, modules, tables, indexes, etc. It isn't
clear whether or not Stephan Koenig currently owns a copy of Access;
if he doesn't, a solution that has to run within Access would be less
than ideal.

--
John F. Eldredge -- john@jfeldredge.com
PGP key available from http://pgp.mit.edu
"Reserve your right to think, for even to think wrongly is better
than not to think at all." -- Hypatia of Alexandria

Sponsored Links