title: Export data from datafile to excel format
body: <p><em><strong>Background:</em></strong></p>
  
  <p>Our company uses Sage Line 50 as our accounting software.  We generate all of our Sales Orders from this program.  We also use MS Access 2010 to store order information and generate our internal shop paperwork and packing slips.</p>
  
  <p><em><strong>The Problem:</em></strong></p>
  
  <p>Data entry redundancy.  We enter information from Customer Purchase Orders into our Sage software, and then enter the same information into the Access database.</p>
  
  <p><em><strong>What I am looking for:</em></strong></p>
  
  <p>A solution that will let me export raw Sales Order data after creating in Sage into MS-Access</p>
  
  <p><em><strong>What I have tried:</em></strong></p>
  
  <p>The export process from Sage only allows CSV exports, and is a manual process that cannot be automated at all.  I am able to produce this export and then run an append query that will import that data into the Access data, but I am looking to automate this process, perhaps on a daily basis.  I have looked into using Crystal Reports (packaged with Sage, which I am told can run automated reports and save in an MS Excel format), but I do not know how to navigate the data files to find the specific sales data I am looking for.</p>