Is there a limit on the # of records to import form a MS Access database?<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />Hi I have been using Acess to query our OBDC database, then I like to import hte raw data into JMP and manipulate it. I find that when the number of records is large, like today almost 3 billion, then it times out during the retrieval. is there a limit to how many can be imported?
Thanks
Re: Is there a limit on the # of records to import form a MS Access database?There's a size limit on an access db.
I think in 2003 it was 2gb, not sure in 2010 versions.
You should be able to connect JMP to an odbc source directly.
