Subscribe Bookmark RSS Feed

Is there a limit on the # of records to import form a MS Access database?

engrmom

Community Member

Joined:

Dec 17, 2012

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

1 REPLY
reeza

Community Trekker

Joined:

Jun 23, 2011

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.