Steven Rubin posted a comment on discussion Help

I am trying to build a large table (105 columns and over a million rows). Using Access, I can use Import / External Data and then give it a big text file (tab separated). It takes barely any time at all. Now I want to do it from Java, so I looked at UCanAccess. First, I tried calls to execute() with INSERT statements, but that took a minute for every thousand rows, which means it would take 17 hours. Next, I tried using prepareStatement() and that halved the time, but still would need 8 hours. Is...