Re: st: ODBC Performance

["Sergiy Radyakin" <Radyakin@aoek.uni-hannover.de>]

Hello Mr. Elliott,

StatTransfer supports convertion of DBF files, but it costs $179.

If you mean DBASE (*.dbf) files -- there is a huge number of free dbf to 
text or csv converters in the net.
Simply convert to text, then use Stata's -infile- with a proper dictionary.

Since many of these converters are DOS utilities -- they can be executed in 
batch mode with the filename as a parameter. The call to this utility can be 
wrapped as an ADO file.

One of the many places you can find such a converter is here:
http://www.sac.sk/files.php?d=19&l=D

(no preference, just the first thing Google yielded by "dbf2txt converter")

You might need to know the type and length of the fields, etc (for Stata's 
dictionary). Most of these utilities will report all the necessary 
information (or it may be already known).


Regards,
  Sergiy




----- Original Message ----- 
From: "David Elliott" <dcelliott@gmail.com>
To: <statalist@hsphsun2.harvard.edu>
Sent: Wednesday, February 28, 2007 1:10 AM
Subject: Re: st: ODBC Performance



> Further to issue of Stata plugins to read in dbfs - are there any
> freely available ones - a casual search does not turn up any leads.
>
> DCE
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/ 
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/