Google Answers Logo
View Question
Q: STATA dta to Excel conversion ( Answered,   0 Comments )
Subject: STATA dta to Excel conversion
Category: Miscellaneous
Asked by: gsalinas-ga
List Price: $20.00
Posted: 13 Dec 2003 00:09 PST
Expires: 12 Jan 2004 00:09 PST
Question ID: 286615
Have a very old (Stata version 1) .dta binary file used as lookup
table for a upgraded control system.
Need to find a two-way file converter (dta to excel and viceversa),
free o shareware if any.
Subject: Re: STATA dta to Excel conversion
Answered By: joey-ga on 13 Dec 2003 19:25 PST
Hi there.

I did a bit of searching and found the following product which can
convert between many different data formats including the common
Excel, Access, and Paradox and the more specialized SAS, Stata,
Matlab, etc.

It's called "Stat/Transfer" and was developed and is marketed by
Circle Systems.  It uses a simple GUI interface to let you choose an
existing file and format (including any Stata file, versions 1-8) then
an output file and format.

The software is available for Mac, Windows, and Linux and is
downloadable online.  Sadly it's not shareware/freeware, but there is
a demo available to try online.  Pricing ranges from $49 to $249,
depending on if you're a student, in an academic setting, or a
commercial user.

You can find more information and download the application at:

Please let me know if I can be of any more assistance.

Searching strategy:

   'stata excel dta'
   found me:

   then 'stat/transfer'

   and finally 'circle systems'

Request for Answer Clarification by gsalinas-ga on 14 Dec 2003 08:02 PST
Hi Joey
I knew before about StatTransfer, days ago downloaded and installed
the working demo. Unfortunately it only handles stata files from
version 4 to 8. When I tried to open my files an error message box
popped up displaying "stata release 1 not supported".

I would be willing to get it whether could handle my files, but it doesnt. 

Please let me know if you can find another program for Windows, able
to handle stata relase 1 to read and to write.


Clarification of Answer by joey-ga on 14 Dec 2003 11:05 PST
That's unfortunate. I read on another site that it handled reading
"all versions" up to 8 (but could only write 4-8).

I don't have a Stata v1 file that I can try, but the following program
implies it can convert Stata files up to version 7.0 to Excel and
other programs.  This is an older application that was later purchased
by SAS and is marketed under their DataFlux division.  The details are
*very* short on DataFlux's site, but the previous publisher's site
provides greater information and lists its conversion databases.


To download a demo:

The original publisher's site with list of supported databases:

The license for this software is roughly $500, so it's a bit more
expensive than the other solution.  I tried to call them to inquire
specifically about Stata v1, but their offices are closed on weekends.

As you have already tried Stat/Transfer, I wouldn't be surprised if
you have already tried this program as well (and may be asking this
question as a last resort.)  I talked to a friend of mine who's an
economist, and he was familiar with these two programs.  He knew of no
other major conversion utilities.

If you find that DBMSCopy cannot work for you and you don't have a
newer copy of Stata around to update your old file into a newer
version, would you be interested in me trying to find someone who
could convert your Stata v1 file into a newer version so that you
could then use those packages?

If I don't hear back from you re: the success of DBMSCopy, I plan to
talk to Stata on Monday (when they have business hours) to inquire
about a solution for you.


Request for Answer Clarification by gsalinas-ga on 15 Dec 2003 06:20 PST
Well I already checked DBMS too, unfortunately handles ony stata v.2
(anyway closer than stattransfer).
If any kind of update application is available (from 1 to whatever) it
must have a way to get it 'old' back again (from newer version to 1),
since our system here only read stata 1, and cannot be upgraded.

Anyway, whatever you find out, just let me know. Apparently there
won't be a single application handling everything, but maybe two or
three of them.



Clarification of Answer by joey-ga on 15 Dec 2003 10:59 PST
Okay, I spoke with the man at Circle Systems (Stat/Transfer) who
developed the software.  He said he believed it at one time handled
Stata v1 files, but he thought he remembered taking out that library. 
He said he will send me the library (a few extra files) which you
could dump into the application directory to get it to work.

He said, though, that he has no way of testing it for sure because he
has no Stata v1 files.  But, he said that if you can't get it to work,
he can open up a copy of your v1 file in a newer version of Stata and
convert it so that you could then use Stat/Transfer.

I spoke to him 5 minutes ago, and I will update you here when I hear back from him.

Clarification of Answer by joey-ga on 15 Dec 2003 11:17 PST
Hi there.

I heard back from him and have placed a ZIP file online that contains
his contact information and the libraries he sent me.

His instructions are to:

"Unzip this in your Stat/Transfer directory and it will replace some
files.  If it does not read the Stata 1 file, I would appreciate it if you
would send it to me." -- again he implied on the phone that he could
convert it into a newer Stata version for you if all else failed.

The full email from him along with his email address is contained in a
text file inside the ZIP file.

IMPORTANT NOTE: This zip file will be available until noon Eastern
time Tuesday December 16th, so please download it before then.

Request for Answer Clarification by gsalinas-ga on 16 Dec 2003 16:38 PST
I forwarded a dta file to the guy at Circle systems. He found
something that have puzzled now. Said my dta files are not standard
stata files (not because of version), but because has a proprietary

In order to clarify this I'll contact the vendor today, since I've
been told this was a standard stata file, but now came clear it's not.

Thanx anyway. Will keep you updated.
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy