Statalist The Stata Listserver


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

Re: Re: st: importing data from excel


From   Joseph Coveney <jcoveney@bigplanet.com>
To   Statalist <statalist@hsphsun2.harvard.edu>
Subject   Re: Re: st: importing data from excel
Date   Thu, 20 Jul 2006 19:10:09 +0900

Julia Spies wrote:

thanks to everyone for the suggestions!

@Svend: The language settings actually appear to be the problem. However,
changing them afterwards does not solve the problem, since switching to
english makes the data appear like in stata before (cut decimal places).

Stata/Transfer does the job perfectly. Since i don't possess it myself i
thought there would be a way around...but well, next time, i can change the
language settings in windows before collecting the data, things should work
out then.

--------------------------------------------------------------------------------

Have you considered using -odbc- to load the values directly into Stata from
the Excel workbook?  I'm guessing that in Excel the underlying numerical
value is stored identically regardless of display, just as for Stata.  If my
guess is correct, then the ODBC route ought not to be affected by regional
settings.

Take a look at http://www.ats.ucla.edu/stat/Stata/faq/odbc.htm for tips on
how to use -odbc- with Excel.

Joseph Coveney


*
*   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