Hi,

I have to import large .mdb files and transfer into stata file. As the databases are saved in 32 byte, I followed instruction from previous discussions and advises online that adding them into user data source through ODBC data source administration and run the data by stata 15 IC 32 bytes.

Code:
 odbc load, table("20110106")
op. sys. refuses to provide memory
    Stata's data-storage memory manager has already allocated 1088m bytes and it just attempted to
    allocate another 16m bytes.  The operating system said no.  Perhaps you are running another
    memory-consuming task and the command will work later when the task completes.  Perhaps you
    are on a multiuser system that is especially busy and the command will work later when
    activity quiets down.  Perhaps a system administrator has put a limit on what you can
    allocate; see help memory.  Or perhaps that's all the memory your computer can allocate to
    Stata.
Although some files works, there are still other files that are too large that exceed 2GB, and therefore stata 32 byte cannot read them. Even if I tried to set memory larger, still cannot read the table.

I also try free version StatTransfer, but seems not work as well. I also attempted to separated the tables in mdb files into smaller tables, but many times it just shows "Cannot open database. It may not be the database that your application recognizes, or the file may be corrupt.", despite of the fact that the database is open in front of me.

Is there anything else I can do?