THE MS ACCESS ADD-IN FOR EXPORTING TO SERVER DATABASES Cover Image

Dodatak (add-in) za izvoz podataka iz MS accessa u serverske baze podataka
THE MS ACCESS ADD-IN FOR EXPORTING TO SERVER DATABASES

Author(s): Bojan Milosavljević
Subject(s): Economy
Published by: Visoka škola za poslovnu ekonomiju i preduzetništvo
Keywords: program add-in; Microsoft Access; databases; SQL; data export; MySQL

Summary/Abstract: The Microsoft Access table and view definition and data export to server databases(such as MySQL, Oracle, SQL Server) add in creation and usage procedure is presented in this paper. The add-inn exposes a number of settings for SQL script generation to create database tables and views, as well as their data into a specified target data base management system (DBMS). Definitions of table relationships are also exportable as foreign key constraints. Support for export to new SUBPs can be added by means of additions of new appropriate definitions. Possibilities for further improvements of the add-in are also considered.

  • Issue Year: 2/2014
  • Issue No: 1
  • Page Range: 45-54
  • Page Count: 10
  • Language: Serbian
Toggle Accessibility Mode