User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Introduction to the JMP Scripting Language

View Translated Thread

Importing Data

Started ‎11-08-2022 by
Modified ‎04-08-2025 by

When your data are saved in a computer file that's not a JMP data table, you can import it into JMP in order to create a JMP data table. The original source file might be a text file, a Microsoft Excel workbook, or a file saved from a relational database. Whether your data are stored in a JMP data table or some other file format, you use the Open function to access your data. When you use the Open function, JMP automatically determines the file type based on the file extension at the end of the character string. The file types that JMP can recognize include text files, Microsoft Excel workbooks, Microsoft Access databases, SAS data sets and transport files, picture file s, JSON files, Python files, and HTML files. There are optional arguments for the Open function that you can use to specify the file characteristics that are different from the defaults.

0 Kudos