So, I've got 3 fairly large datasets (~ 1.5mil records each. 670mb total) that I need to be exported from SAS to Access as tables in a new database. We have code that is part of a weekly automated process, and like every other week the code bombs out with this error: ERROR: CLI execute error: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. Unfortunately, I have to use Access instead of a real database (it needs to be accessible to many other people who don't have/don't know other software), so I can't just upgrade to MySQL or anything. Any suggestions on how to work with/around this error? I'd be hugely thankful as this has been a pretty consistent thorn in my side!
... View more