Saving multiple Excel files as Stata files

[Budu Gulo]

In "C:\Users\budug\OneDrive\Documents\School\Projects ", I have a few Excel files, namely data_2004, data_2005,...,data_2018. Each file has exactly one sheet and row 1 contains variables' names. How can I save each Excel as a Stata file, retaining the same name?

[William Lisowski]

The user-written xls2dta command available from SSC is often recommended on Statalist for problems like the one you have.

ssc describe xls2dta

[Budu Gulo]

Thank you William Lisowski.
The following code worked.

 xls2dta , save(C:\Users\budug\OneDrive\Documents\School\Projects\Stata_Files) : import excel C:\Users\budug\OneDrive\Documents\School\Projects\, firstrow