[daniel klein]

Dear Daniel, Thanks for the suggestion. It seems to me that xls2dta is an interesting and helpful command for the task. But if you have tried the files (from Robert, #8) [...] you will find that the variables names are treated as data in each file, and as such, the variables names are changed to A, B, C, and so on. Any suggestion to deal with this issue?

Yes. You can specify any of the import excel options with xls2dta

xls2dta , recursive clear importopts(firstrow) : append using mydata

Best
Daniel

[River Huang]

Yes. You can specify any of the import excel options with xls2dta

xls2dta , recursive clear importopts(firstrow) : append using mydata

Best
Daniel

Dear Daniel, many thanks! It works quite well, and I like this "xls2dta" command.