Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: ODBC Performance


From   "Sergiy Radyakin" <Radyakin@aoek.uni-hannover.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   Re: st: ODBC Performance
Date   Wed, 28 Feb 2007 11:09:20 +0100

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index