Hi all,

So I am trying to append 3 excel sheets into one Stata file but I would need to destring one of the sheets (Sheet3) first in order to append. I am using the xls2dta command to append but it says "previous command was not xls2dta". What should I do?

This is what I did:

ssc install xls2dta
xls2dta ,allsheets : import excel using "/Users/xyz/Downloads/list_of_treaties.xlsx", firstrow clear
use list_of_treaties_3.dta
destring YEAR YEAR_START YEAR_VALID, replace force
xls2dta ,clear : append


Thank you!