Pedro,
You can use Stata/Transfer or you can save/export from Access to a .txt file
and use the -insheet- command to import them to Stata.
When you -tsset- your data you are declaring that yours is a timeseries (or
longitudinal type), therefore your panelid variable must appear just once in
every cross section (e.g. every year). If you have two of more panelid
values for the same time variable, then Stata won't be able to understand
the structure of your data.
Rafa
----- Original Message -----
From: "Pedro Juan Garc�a Teruel" <[email protected]>
To: "Statalist" <[email protected]>
Sent: Friday, August 13, 2004 2:13 PM
Subject: st: export data
> Hello,
> How can I export data from Microsoft Access to Stata?
> Im working with a panel, and sometime, when I use copy and paste, and
> write tsset I get the next text:
> repeated time values within panel
> r(451);
>
>
>
>
> --
>
>
> *
> * 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/