So I have an access macro which runs two vba functions 10 times. Its supposed to import a messy text file, convert it into a table, take certain columns into a query to then export it into an excel sheet. Before I run the code the file is about 300,000 KB, as it is running it gets through 8 of the imports/exports before the file goes over 2,000,000 kb and error 3049 (One more reason that makes this error happens is the file size limit is 2 GB and if you try to add data which get exceeds with 2 GB limit.) Also, I have it clear the two tables (I haven't tried clearing anything with my query tables just actual tables) during every iteration of the macro. HOW DO I FIX THIS!!!!!!!! Thank you in advance because I have no clue from here how to save this memory.