Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: stata data editor
From
Andrew Dyck <[email protected]>
To
[email protected]
Subject
Re: st: stata data editor
Date
Thu, 27 Oct 2011 19:33:25 -0600
Hi Tuki,
You might also consider using ODBC, if you are using windows, and it
sounds like you probably are. If so, you can directly import the data
from Access to Stata using SQL.
local dsn = "dsn_name"
odbc load, exec("SELECT * FROM data_table) dsn("`dsn'")
Obviously, you'll need to setup a data source name (DSN) for your file
first using ODBC, but then you'll be good to go. Allows for
reproducibility and you can even query a subset of the table in your
access DB if need be. See -help odbc- for more info.
Good luck!
Andrew
On Wed, Oct 26, 2011 at 7:02 AM, Ronan Conroy <[email protected]> wrote:
>
> On 2011 DFómh 26, at 13:41, Tuki wrote:
>
> > Hi
> > Due to the size of the dataset saved in “Microsoft office access”, I can’t
> > use the common command “copy” and “paste” to copy my original dataset saved
> > in “Microsoft office access” to stata’s data editor, I wonder how to
> > divide the original dataset and copy it into stata’s data editor part by
> > part?
>
> You might consider saving the data to a plain text file as an intermediate step. Copying and pasting is a process that leaves no audit trail. You either do it right or do it wrong, but no-one knows which you did.
>
> Ronán Conroy
> [email protected]
> Associate Professor
> Division of Population Health Sciences
> Royal College of Surgeons in Ireland
> Beaux Lane House
> Dublin 2
>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/