OFM Basic: From Excel to Access Database – Practical Step-by-Step Guide

In many production teams, well and production data are initially compiled in Excel. However, when moving into OFM Basic for analysis, engineers often face difficulties structuring the data correctly into a Microsoft Access database (.mdb).

To address this common challenge, Petrotopic has prepared a practical user guide:

“OFM Basic: From Excel to Database and Open.”

What This Guide Covers

This step-by-step guide explains:

How to prepare Excel sheets properly

How to create tables in Microsoft Access

How to transfer data correctly

How to save the database in .mdb format

How to define the workspace and database in OFM

The guide is written in a simple and practical format, making it suitable for engineers with limited database experience.

Who Should Read This

Junior Production Engineers

Production Technologists

Petroleum Engineering students

Engineers new to OFM Basic

Proper data preparation is the foundation of reliable production analysis. A well-structured database ensures smoother workflow and reduces technical errors inside OFM.

View the user guide here
📥 Download the excel template

Petrotopic will continue sharing practical tools and knowledge to support petroleum engineers in daily operations.