title: Excel file too large - 340 mb - Migrate to access?
body: <p>I have an excel file about 340 mb which contains more than 2000 worksheets and dozens of long VBA program. The file is getting so large that it takes around 10-15 mins to open the file and often get into "NO RESPONSE", "NOT ENOUGH USEABLE RESOURCES" when I save or debug the file.</p>
  
  <p>I searched online people suggest migrating to Acesss. However, I have never used Access before. SO I wonder</p>
  
  <p>1) How to migrate the excel file to access? 
  2) Will the VBA program be carried to the new access file 
  3) Do i need to modify the excel VBA code to fit Access?
  2) Can Access handle a 300-500mb file?</p>
  
  <p>thank you</p>