Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: stata data editor

From   Andrew Dyck <>
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!


On Wed, Oct 26, 2011 at 7:02 AM, Ronan Conroy <> 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
> Associate Professor
> Division of Population Health Sciences
> Royal College of Surgeons in Ireland
> Beaux Lane House
> Dublin 2
> *
> *   For searches and help try:
> *
> *
> *

*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index