Subscribe Bookmark RSS Feed

Importing an SQL file directly into JMP v12.1

d_barnett

Community Trekker

Joined:

Nov 30, 2011

I have downloaded an sql file from Open Source Shakespeare: search Shakespeare's works, read the texts ( attached) and wish to do some data analysis on it to demonstrate the use of JMP at a non-work environment . However I can't seem to open it up into JMP as I'm not quite sure how to do it without the aid of a connection/ data source .dsn file.

I'm not sure what format this is going to give me in JMP but getting the information in is the first step. there is another Microsoft Access file that I could use to import the data but it's not my preferred route.

I'm sure I've seen this done before but could someone let me know the best way to go about this please?

Regards

David