Dr

[Mohammad Hassan]

I try to import a Excel file but it shows "<istmt>: 3499 import_excel_import_file() not found". How can I import the file

[Jared Greathouse]

import exc [filename]

[Mohammad Hassan]

I am using STATA 15. But I am unable to import Excel/CSV files

[Jared Greathouse]

I don't believe you. Show me what happens when you do

cls
import exc "https://evs.nci.nih.gov/ftp1/CDISC/SDTM/SDTM%20Terminology.xls", clear

assuming you have internet, this should work. And if not, you need to give me detail about your code.

[Mohammad Hassan]

Not working. Shows " r(100)"

[Jared Greathouse]

"Not working" doesn't tell me anything. Please, show me the code you used AND the error code (not just the number, the text of the error too). We need to see the exact code you used. The code, and the description Stata tells you about the error.

[Mohammad Hassan]

import excel "C:\Users\uqmhas20\OneDrive - The University of Queensland\Desktop\7_Ab_RNA_funnel plot.xlsx", she
> et("Antibody") firstrow
(import_excel_import_file() in lmataado, compiled by Stata 15.1, is too new to be run by this version of Stata
and so was ignored)

[Jared Greathouse]

Oh. See, now this makes sense now!!!!! I began using Stata seriously around 15.1, so I can't comment. Perhaps someone who's used it since before then may comment, say Nick Cox or Clyde Schechter ?

[Clyde Schechter]

(import_excel_import_file() in lmataado, compiled by Stata 15.1, is too new to be run by this version of Stata
and so was ignored)

It seems that you have an incompletely updated version 15. Probably you are running version 15.0, but some of your files have been updated to 15.1 and others have not. That's not a usable configuration. Run -update all, force- to bring your installation up to the final version 15.1. (There is no charge for doing this.) Then try running your code again. It should work.