ComboCurve: ARIES Export - (Blocked) When Daily Production Data Exceeds 1mm Lines

ComboCurve: ARIES Export - (Blocked) When Daily Production Data Exceeds 1mm Lines

If you receive an error such as this when export to ARIES .accdb:



This article describes a workflow in Excel using VBA to allow export of CC daily prod data to .csv so that it can be imported natively into ARIES.  

Note: Update 10/6/2025 - An update has been made to the ComboCurve daily production export which now allows date format in mm/dd/yyyy so that the VBA workflow below is no longer needed.  Now, users can ensure 
1) Export with the ID that the ARIES database was exported with (ChosenID or INPTID for example)
2) Minimize extraneous data columns like Well Name, Well Number or API not used for the id in #1 above
3) Change the headers in the CSV with notepad (or similar) or Access import to PROPNUM, D_DATE, OIL, GAS, WATER
4) Import to ARIES in Access via External Data==>New Data Source==>From File==>Text File==>Append a copy of the records to the table: AC_DAILY (and specify the file)

Note that we are currently working on a secondary export for the .csv file along with the .accdb to further speed up the process.

Below is a video on the above steps: