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

Question

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

reeza · Answer

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.