Hi,
One of the easiest way to transfer data from excel is to first save as a
*.csv file (comma seperated -- we have that facility in excel) and then
insheet...
insheet using file.csv, comma
cheers,
Prabhu
----- Original Message -----
From: "Clara Soh" <[email protected]>
To: <[email protected]>
Sent: Wednesday, May 14, 2003 4:02 PM
Subject: st: insheet Q
> hi statalist,
>
> I'm having problems importing data into Stata. My data is in excel,
> (saved it as a *.raw file text format, tab delilimited). when i use
> insheet to import the data, most of the data get imported correctly, but
> a few observations get dropped or changed. Insheet is pretty
> straightforward, and i can't figure out what is going wrong. I have
> about 30,000 observations, which is well under the 66,000 limit that
> excel can handle, but it's too many to go through the data by hand to
> manually correct the observations that are dropped. And some of the
> values are imported, but changed.
>
> i tried reimporting the data, but which particular values are changed
> pretty much random each time, so i can't predict where i'll need to fix
> the data.
>
> does anyone know if this is a bug, or if there is something special
> that i need to do?
> thanks
> clara
> *
> * 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/
*
* 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/
