Results 1 to 2 of 2

Thread: Conversion of ORACLE Data to Microsoft Access

  1. #1
    Join Date
    Aug 2004
    ACC: Conversion of ORACLE Data Types to Microsoft Access

    Column, or field, data types are different for each database management system. This means that when you are accessing table structures from other database management systems, a conversion, or data type mapping, must occur. This article describes the data type mapping between ORACLE and Microsoft Access data types.

    The following table demonstrates data type mapping between ORACLE and Microsoft Access data types:

    ORACLE data type Maps to Microsoft Access data type
    Char(n) Text(n)
    VarChar(n) Text(n)
    Long Memo
    Date Date/Time
    Long Raw Ole Object
    Float Double
    RowID Text(18)
    Smallint Text(255)

    Note that the Smallint data type is the same as an ORACLE data type of

    In ORACLE, the creator of the table can define the precision (the total number of digits) and scale (the number of digits to the right of the decimal point) for columns with Number data types. If a Number data type is specified without a precision or scale, the column defaults to a data type of Number(9,2). The scale limit is 38, and a scale without a precision is allowed. Values with different precisions and scales are mapped as below:

    ORACLE number Microsoft Access data type
    Scale = 0 and
    precision <= 4 Integer
    precision <= 9 Long Integer
    precision <= 15 Double
    Scale > 0 and <= 4
    precision <= 15 Double
    Scale > 4 and/or
    precision > 15 Text

    If an ORACLE data type is defined with a precision and scale that does not map to any data type in Microsoft Access, it will be mapped to a text data type. For example, an ORACLE Smallint data type, which is actually a Number(38,0) data type, will map into Microsoft Access as a text data type because Microsoft Access does not have a number value of 38 precision.

    ? Microsoft Access 1.0 Standard Edition
    ? Microsoft Access 1.1
    ? Microsoft Access 2.0 Standard Edition
    ? Microsoft Access 95 Standard Edition
    ? Microsoft Access 97 Standard Edition

  2. #2

    Migrating almost any data

    I use data loader for migrating almost any data, it helps me to convert MSSQL to MYSQL, MS access to MSSQL, mysql, csv loader, foxpro and MSSQL to MS access, MYSQl, CSV, foxpro etc. In my view this is a best Data Migration Tool

    Download Free :

Similar Threads

  1. phpBB2 conversion to SMF
    By vern in forum Announcements and Suggestions
    Replies: 4
    Last Post: 09-26-2005, 01:40 AM
  2. How to Import Microsoft Access Data
    By regix in forum Windows - General Topics
    Replies: 0
    Last Post: 01-01-2005, 03:13 AM
  3. Microsoft Word HTML conversion problem with Fedora Apache
    By starfish in forum Linux - Software, Applications & Programming
    Replies: 0
    Last Post: 05-09-2004, 04:33 PM
  4. mp3 conversion
    By doggiebone in forum Redhat / Fedora
    Replies: 1
    Last Post: 01-10-2003, 02:22 AM
  5. PHP conversion
    By paradox in forum Announcements and Suggestions
    Replies: 0
    Last Post: 12-26-2001, 08:23 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts