Microsoft Access

From Oracle FAQ
Jump to: navigation, search

Microsoft Office Access is a relational database management system provided by Microsoft as part of their Office suite for personal and small office scale database applications. Access ships with Microsoft's Jet Database Engine and graphical software development tools.

Migration to/from Oracle[edit]

Data can be migrated from Access to Oracle with Oracle's SQL Developer tool. Manual migration is also possible by linking the Oracle tables in Access via ODBC. If all else fails, export the data to CSV files and use SQL*Loader to load it into Oracle tables.

Also see[edit]

  • SQL Server, Microsoft's flagship database management system.

External links[edit]