Re: AW: st: insheet command

[spollard777@comcast.net]

Greetings.

For very large Excel data sets, I use the ODBC command to import the data and it avoids any conversion to csv issues that may arise.

Steve

> -------------- Original message -------------- 
>
> > Dear Ronnie and others, 
> > 
> > thanks a lot! It worked fine when I simply copied from Excel and put 
> > into Stata data editor. 
> > 
> > Armen 
> > 
> > -----Urspr�ngliche Nachricht----- 
> > Von: owner-statalist@hsphsun2.harvard.edu 
> > [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Ronnie 
> > Babigumira 
> > Gesendet: Freitag, 23. Juli 2004 16:08 
> > An: statalist@hsphsun2.harvard.edu 
> > Betreff: Re: st: insheet command 
> > 
> > Save file as a text (tab delimited file) in excel. In 
> > stata insheet using yourfile.txt (this should work 
> > well and if your first row in excel has variable names 
> > even better, stata will take these as the variable 
> > names as it is insheeting your data) 
> > 
> > Ronnie 
> > 
>  > Ps: Remember to increase your memory before insheeting 
> > 
> > 
> > 
> > * 
> > * 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/