f



Importing MS Office Excel Comma Separated Values Files into a MS Access 2003 database

Hi,
I have been tasked with Importing MS Office Excel Comma Separated
Values Files into a MS Access 2003 database. These files were
exported
from a DB2 database.I have also been given the DDL code. I have
Googled a solution to this task and have tried creating these tables
using the DDL code in a query within a blank MS Access database. Is
there a more expedient way to achieve this? I noticed, for example,
that a field in DB2 has a data type of "decimal" while the same field
in MS Access 2003 would have the data type of "number".

Thanks,
Zuf


What follows is the DDL:


--------------------------------------------------
-- Create Table ENT01.ACCOUNTABILITY_T
--------------------------------------------------
Create table ENT01.ACCOUNTABILITY_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    COMMISOID                      DECIMAL(22)                     ,
    RESPONOID                      DECIMAL(22)                     ,
    COMMISOBJECTTYPE               CHARACTER(5)                    ,
    RESPONOBJECTTYPE               CHARACTER(5)                    ,
    ACCOUNTYPEOID                  DECIMAL(22)                     ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT055TS Index in ENT055IS  ;


--------------------------------------------------
-- Create Table ENT01.ACL_T
--------------------------------------------------
Create table ENT01.ACL_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    ACLNAME                        CHARACTER(100)                  ,
    ACTIVE                         CHARACTER(1)                    ,
    PREVIOVERSIO                   DECIMAL(22)                     ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT052TS Index in ENT052IS  ;


--------------------------------------------------
-- Create Table ENT01.ACLENTRY_T
--------------------------------------------------
Create table ENT01.ACLENTRY_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    GROUPOID                       DECIMAL(22)                     ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT051TS Index in ENT051IS  ;


--------------------------------------------------
-- Create Table ENT01.ADDRES_T
--------------------------------------------------
Create table ENT01.ADDRES_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    ADDITIADDRESINFO               VARCHAR(254)                    ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT008TS Index in ENT008IS  ;


--------------------------------------------------
-- Create Table ENT01.ADDRESOTHER_T
--------------------------------------------------
Create table ENT01.ADDRESOTHER_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    ADDRESLINE                     VARCHAR(254)                    ,
    GEOLOCATOID                    DECIMAL(22)                     ,
    ZIPPLUSFOUR                    CHARACTER(20)                   ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT012TS Index in ENT012IS  ;


--------------------------------------------------
-- Create Table ENT01.AUDIT_T
--------------------------------------------------
Create table ENT01.AUDIT_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    TABLENAME                      CHARACTER(5)                    ,
    ACTVTY                         CHARACTER(5)                    ,
    SITEADDCHANGE                  DECIMAL(22)                     ,
    USERADDCHANGE                  DECIMAL(22)                     ,
    ROWADDED                       TIMESTAMP           NOT NULL    ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         )
in ENT026TS Index in ENT026IS  ;


--------------------------------------------------
-- Create Table ENT01.CODEVALUE_T
--------------------------------------------------
Create table ENT01.CODEVALUE_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    CODETYPE                       CHARACTER(20)                   ,
    CODE                           CHARACTER(5)                    ,
    SHORTDESC                      CHARACTER(50)                   ,
    LONGDESC                       CHARACTER(100)                  ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT017TS Index in ENT017IS  ;


--------------------------------------------------
-- Create Table ENT01.CODEVALUEVERIFY_T
--------------------------------------------------
Create table ENT01.CODEVALUEVERIFY_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    CODETYPE                       CHARACTER(20)                   ,
    CODE                           CHARACTER(5)                    ,
    SHORTDESC                      CHARACTER(50)                   ,
    LONGDESC                       CHARACTER(100)                  ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    VERIFYBY                       DECIMAL(22)                     ,
    VERIFYDATE                     TIMESTAMP                       ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT011TS Index in ENT011IS  ;


--------------------------------------------------
-- Create Table ENT01.DATE_T
--------------------------------------------------
Create table ENT01.DATE_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    DATE                           DATE                            ,
    TIME                           TIME                            ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT013TS Index in ENT013IS  ;


--------------------------------------------------
-- Create Table ENT01.DISCREVALIDA_T
--------------------------------------------------
Create table ENT01.DISCREVALIDA_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    VALIDATNAME                    CHARACTER(50)                   ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT023TS Index in ENT023IS  ;


--------------------------------------------------
-- Create Table ENT01.EMAIL_T
--------------------------------------------------
Create table ENT01.EMAIL_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    EMAILADDRES                    CHARACTER(50)                   ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT005TS Index in ENT005IS  ;


--------------------------------------------------
-- Create Table ENT01.FOLLOWUP_T
--------------------------------------------------
Create table ENT01.FOLLOWUP_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    FOLLOWUPDATE                   DATE                            ,
    FOLLOWUPDONE                   CHARACTER(1)                    ,
    FOLLOWUPSCHEDU                 CHARACTER(1)                    ,
    REASON                         CHARACTER(5)                    ,
    COMPLY                         CHARACTER(1)                    ,
    COMMENT                        VARCHAR(254)                    ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT049TS Index in ENT049IS  ;


--------------------------------------------------
-- Create Table ENT01.GEOGRALOCATI_T
--------------------------------------------------
Create table ENT01.GEOGRALOCATI_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    CITY                           DECIMAL(22)                     ,
    STATE                          DECIMAL(22)                     ,
    ZIPCODE                        DECIMAL(22)                     ,
    COUNTY                         DECIMAL(22)                     ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT016TS Index in ENT016IS  ;


--------------------------------------------------
-- Create Table ENT01.GROUP_T
--------------------------------------------------
Create table ENT01.GROUP_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    GROUPNAME                      CHARACTER(100)                  ,
    ACTIVE                         CHARACTER(1)                    ,
    PREVIOVERSIO                   DECIMAL(22)                     ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT050TS Index in ENT050IS  ;


--------------------------------------------------
-- Create Table ENT01.IDENTI_T
--------------------------------------------------
Create table ENT01.IDENTI_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    IDENTI                         CHARACTER(20)                   ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT007TS Index in ENT007IS  ;


--------------------------------------------------
-- Create Table ENT01.INTERNADDRES_T
--------------------------------------------------
Create table ENT01.INTERNADDRES_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    MAILCODE                       CHARACTER(20)                   ,
    ADDRESLINE                     VARCHAR(254)                    ,
    CITY                           CHARACTER(50)                   ,
    REGIONDESIGN                   CHARACTER(70)                   ,
    CONTRY                         CHARACTER(5)                    ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT009TS Index in ENT009IS  ;


--------------------------------------------------
-- Create Table ENT01.LEGALLANDDESC_T
--------------------------------------------------
Create table ENT01.LEGALLANDDESC_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    TOWNSHIP                       CHARACTER(10)                   ,
    RANGE                          CHARACTER(10)                   ,
    SECTIONUMBER                   INTEGER                         ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT054TS Index in ENT054IS  ;


--------------------------------------------------
-- Create Table ENT01.LOCATO_T
--------------------------------------------------
Create table ENT01.LOCATO_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    CODEVALUEOBJECTID              DECIMAL(22)                     ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    COMMENT                        VARCHAR(254)                    ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT004TS Index in ENT004IS  ;


--------------------------------------------------
-- Create Table ENT01.MESSAG_T
--------------------------------------------------
Create table ENT01.MESSAG_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    MESSAGTYPE                     DECIMAL(22)                     ,
    MESSAGCODE                     CHARACTER(8)                    ,
    SHORTDESC                      CHARACTER(50)                   ,
    LONGDESC                       CHARACTER(100)                  ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT040TS Index in ENT040IS  ;


--------------------------------------------------
-- Create Table ENT01.NAME_T
--------------------------------------------------
Create table ENT01.NAME_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    NAME                           CHARACTER(100)                  ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT002TS Index in ENT002IS  ;


--------------------------------------------------
-- Create Table ENT01.OBJECTRELATE_T
--------------------------------------------------
Create table ENT01.OBJECTRELATE_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    OBJECTOWNERID2                 DECIMAL(22)                     ,
    OBJECTTYPERELATE               CHARACTER(5)                    ,
    RELATETYPEID                   DECIMAL(22)                     ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT018TS Index in ENT018IS  ;


--------------------------------------------------
-- Create Table ENT01.OBJECTSEQUENNUM_T
--------------------------------------------------
Create table ENT01.OBJECTSEQUENNUM_T (
    SEQUENNUMBER                   INTEGER                         )
in ENT039TS Index in ENT039IS  ;


--------------------------------------------------
-- Create Table ENT01.OBSERVCOMPOS_T
--------------------------------------------------
Create table ENT01.OBSERVCOMPOS_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    RECORDDATE                     TIMESTAMP                       ,
    OBSERVDATE                     TIMESTAMP                       ,
    COMMENT                        VARCHAR(254)                    ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    OBSERVTYPEID                   DECIMAL(22)                     ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT020TS Index in ENT020IS  ;


--------------------------------------------------
-- Create Table ENT01.OBSERVDEFAUL_T
--------------------------------------------------
Create table ENT01.OBSERVDEFAUL_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    DEFAULVALUE                    DECIMAL(10,3)                   ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT045TS Index in ENT045IS  ;


--------------------------------------------------
-- Create Table ENT01.OBSERVPRIMIT_T
--------------------------------------------------
Create table ENT01.OBSERVPRIMIT_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    RECORDDATE                     TIMESTAMP                       ,
    OBSERVDATE                     TIMESTAMP                       ,
    COMMENT                        VARCHAR(254)                    ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    QUANTI                         DECIMAL(10,3)                   ,
    UNITOFMEASUR                   CHARACTER(5)                    ,
    OBSERVTYPEID                   DECIMAL(22)                     ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT021TS Index in ENT021IS  ;


--------------------------------------------------
-- Create Table ENT01.OBSERVTEXT_T
--------------------------------------------------
Create table ENT01.OBSERVTEXT_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    OBSERVTEXT                     VARCHAR(254)                    ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT043TS Index in ENT043IS  ;


--------------------------------------------------
-- Create Table ENT01.OBSERVTYPE_T
--------------------------------------------------
Create table ENT01.OBSERVTYPE_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    PHENOMNAME                     CHARACTER(50)                   ,
    MULTIVALUE                     CHARACTER(1)                    ,
    VALIDAOID                      DECIMAL(22)                     ,
    VALIDAOBJECTTYPE               CHARACTER(5)                    ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT022TS Index in ENT022IS  ;


--------------------------------------------------
-- Create Table ENT01.PARTY_T
--------------------------------------------------
Create table ENT01.PARTY_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT001TS Index in ENT001IS  ;


--------------------------------------------------
-- Create Table ENT01.PASSWO_T
--------------------------------------------------
Create table ENT01.PASSWO_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    PASSWO                         CHARACTER(20)                   ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT053TS Index in ENT053IS  ;


--------------------------------------------------
-- Create Table ENT01.PERSONNAME_T
--------------------------------------------------
Create table ENT01.PERSONNAME_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    TITLE                          CHARACTER(5)                    ,
    FIRSTNAME                      CHARACTER(20)                   ,
    MIDDLENAME                     CHARACTER(20)                   ,
    SUFFIX                         CHARACTER(5)                    ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT003TS Index in ENT003IS  ;


--------------------------------------------------
-- Create Table ENT01.PHONE_T
--------------------------------------------------
Create table ENT01.PHONE_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    EQUIPMTYPE                     CHARACTER(5)                    ,
    CONTRY                         CHARACTER(5)                    ,
    AREACODE                       CHARACTER(5)                    ,
    PREFIX                         CHARACTER(3)                    ,
    SUFFIX                         CHARACTER(4)                    ,
    EXTENS                         CHARACTER(10)                   ,
    INTERNPHONE                    CHARACTER(10)                   ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT006TS Index in ENT006IS  ;


--------------------------------------------------
-- Create Table ENT01.PROPER_T
--------------------------------------------------
Create table ENT01.PROPER_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    PROPERNAME                     CHARACTER(100)                  ,
    PROPERVALUE                    CHARACTER(50)                   ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT044TS Index in ENT044IS  ;


--------------------------------------------------
-- Create Table ENT01.RANGEVALIDA_T
--------------------------------------------------
Create table ENT01.RANGEVALIDA_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    VALIDATNAME                    CHARACTER(50)                   ,
    VALIDUNIT                      CHARACTER(5)                    ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT024TS Index in ENT024IS  ;


--------------------------------------------------
-- Create Table ENT01.RATE_T
--------------------------------------------------
Create table ENT01.RATE_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    RATETYPE                       CHARACTER(5)                    ,
    RATEAMOUNT                     DECIMAL(9,2)                    ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT047TS Index in ENT047IS  ;


--------------------------------------------------
-- Create Table ENT01.REFUGE_T
--------------------------------------------------
Create table ENT01.REFUGE_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    ARRIVEDATE                     DATE                            ,
    ORIGINCONTRY                   CHARACTER(5)                    ,
    FIRSTPLACEMSITE                CHARACTER(50)                   ,
    REFUGETYPE                     CHARACTER(5)                    ,
    ACCOMPMINOR                    CHARACTER(1)                    ,
    PREGNANT                       CHARACTER(1)                    ,
    COMMENT                        VARCHAR(254)                    ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT046TS Index in ENT046IS  ;


--------------------------------------------------
-- Create Table ENT01.REPLICLOG_T
--------------------------------------------------
Create table ENT01.REPLICLOG_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    SITEREPLICNUMBER               INTEGER                         ,
    SITEREPLICNEWNUM               INTEGER                         ,
    LASTREPLICNUMBER               INTEGER                         ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT014TS Index in ENT014IS  ;


--------------------------------------------------
-- Create Table ENT01.REPLICSEQUENNUM_T
--------------------------------------------------
Create table ENT01.REPLICSEQUENNUM_T (
    SEQUENNUMBER                   INTEGER                         )
in ENT042TS Index in ENT042IS  ;


--------------------------------------------------
-- Create Table ENT01.ROLE_T
--------------------------------------------------
Create table ENT01.ROLE_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    ROLENAME                       CHARACTER(50)                   ,
    DESCRI                         VARCHAR(254)                    ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT041TS Index in ENT041IS  ;


--------------------------------------------------
-- Create Table ENT01.SECURILOG_T
--------------------------------------------------
Create table ENT01.SECURILOG_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    ATTEMPUSERNAME                 CHARACTER(20)                   ,
    ATTEMPPASSWO                   CHARACTER(20)                   ,
    RECORDDATE                     TIMESTAMP                       ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT033TS Index in ENT033IS  ;


--------------------------------------------------
-- Create Table ENT01.SECURIPOLICY_T
--------------------------------------------------
Create table ENT01.SECURIPOLICY_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    MINPASSLENGTH                  INTEGER                         ,
    MAXNUMTRIES                    INTEGER                         ,
    PASSWOEXPIRE                   INTEGER                         ,
    TIMEOUT                        INTEGER                         ,
    PASSWORETENT                   INTEGER                         ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT032TS Index in ENT032IS  ;


--------------------------------------------------
-- Create Table ENT01.SECURIPRINCI_T
--------------------------------------------------
Create table ENT01.SECURIPRINCI_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    USERNAME                       CHARACTER(20)                   ,
    BEGINDATE                      TIMESTAMP                       ,
    ENDDATE                        TIMESTAMP                       ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    PASSWOLASTCHANGE               TIMESTAMP                       ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT019TS Index in ENT019IS  ;


--------------------------------------------------
-- Create Table ENT01.SERVIC_T
--------------------------------------------------
Create table ENT01.SERVIC_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    SERVICDATE                     DATE                            ,
    SERVICRATEOID                  DECIMAL(22)                     ,
    SERVICSITEOID                  DECIMAL(22)                     ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT048TS Index in ENT048IS  ;


--------------------------------------------------
-- Create Table ENT01.SITE_T
--------------------------------------------------
Create table ENT01.SITE_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    SITEKEY                        CHARACTER(16)                   ,
    DBIDENTI                       INTEGER                         ,
    VOICERESPONPIN                 SMALLINT                        ,
    LASTREPLICNUMBER               INTEGER                         ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT038TS Index in ENT038IS  ;


--------------------------------------------------
-- Create Table ENT01.STREETADDRES_T
--------------------------------------------------
Create table ENT01.STREETADDRES_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    HOUSENUMBER                    CHARACTER(10)                   ,
    STREETPREDIRECT                CHARACTER(5)                    ,
    STREETNAME                     CHARACTER(70)                   ,
    STREETPOSTDIRECT               CHARACTER(5)                    ,
    SECONDUNITINDICA               CHARACTER(5)                    ,
    SECONDUNITNUMBER               CHARACTER(10)                   ,
    STREETSUFFIXABBR               CHARACTER(5)                    ,
    GEOLOCATOID                    DECIMAL(22)                     ,
    ZIPPLUSFOUR                    CHARACTER(20)                   ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT010TS Index in ENT010IS  ;


--------------------------------------------------
-- Create Table ENT01.TYPE_T
--------------------------------------------------
Create table ENT01.TYPE_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    DESCTYPE                       CHARACTER(20)                   ,
    CODE                           CHARACTER(5)                    ,
    DESCRI                         CHARACTER(50)                   ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT036TS Index in ENT036IS  ;


--------------------------------------------------
-- Create Table ENT01.VALIDRANGES_T
--------------------------------------------------
Create table ENT01.VALIDRANGES_T (
    OBJECTID                       DECIMAL(22)         NOT NULL    ,
    OBJECTOWNERID                  DECIMAL(22)                     ,
    LOWVALUE                       DECIMAL(10,3)                   ,
    HIGHVALUE                      DECIMAL(10,3)                   ,
    INCLUDEHIGH                    CHARACTER(1)                    ,
    INCLUDELOW                     CHARACTER(1)                    ,
    OBJECTTYPE                     CHARACTER(5)                    ,
    ACL                            DECIMAL(22)                     ,
    REPLICNUMBER                   INTEGER                         ,
    ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
in ENT025TS Index in ENT025IS  ;
0
zufie
5/14/2010 6:45:27 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

2 Replies
1668 Views

Similar Articles

[PageSpeed] 59

Greetings,

It sounds like what you have is a .cvs file.  If this is the case then
you can write a routine using the Open (textfile) function and Line
Input to read in the lines.  Or, if coding isn't your thing, you can
search for VBA scripts that can read comma delimited (.csv) files and
implement that into your project.  Here is a sample that might work for
you:

Sub ReadCSVfile()
   Dim s As String, RS As DAO.Recordset
   Set RS = CurrentDb.OpenRecordset("tblText")
   Open "C:\1A\test1.csv" For Input As #1
   Do While Not EOF(1)
      Line Input #1, s
      RS.AddNew
      RS(0) = s
      RS.Update
      Debug.Print s
   Loop
   Close #1
   RS.Close
End Sub

This routine reads each line of a .csv file and writes it to a table
("tblText") which only contains one field -- a memo field (incase the
lines contain a lot of text).

The next step is then to parse out each field of data which would be
delimited by commas.  You can use the Split function for this.

Sub SplitString1()
   Dim str1 As String, str2 As Variant, str3 As Variant
   str1 = "a,b,c,d"
   str2 = Split(str1, ",")
   For Each str3 In str2
      Debug.Print str3
   Next
End Sub

Then you would write the contents of each line to a 2nd table that would
contain the same number of fields at the source data.

HTH


Rich

*** Sent via Developersdex http://www.developersdex.com ***
0
Rich
5/14/2010 7:14:10 PM
zufie wrote:
> Hi,
> I have been tasked with Importing MS Office Excel Comma Separated
> Values Files into a MS Access 2003 database. These files were
> exported
> from a DB2 database.I have also been given the DDL code. I have
> Googled a solution to this task and have tried creating these tables
> using the DDL code in a query within a blank MS Access database. Is
> there a more expedient way to achieve this? I noticed, for example,
> that a field in DB2 has a data type of "decimal" while the same field
> in MS Access 2003 would have the data type of "number".
> 
> Thanks,
> Zuf

Can you tell us why you are concerned with DLL code etc for importing an 
  Excel CSV file into Access?

If the file is already exported to a CSV file, simply append it.  Look 
at TransferText in help.  Heck, if they're Excel files look at 
TransferSpreadsheet as well.

Or link to the CSV files or XLS files.  Then run an append query.

Anyway, I may be misreading your post.  But I would be unconcerned about 
the DLL code but instead be focused on the output files.



> 
> 
> What follows is the DDL:
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.ACCOUNTABILITY_T
> --------------------------------------------------
> Create table ENT01.ACCOUNTABILITY_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     COMMISOID                      DECIMAL(22)                     ,
>     RESPONOID                      DECIMAL(22)                     ,
>     COMMISOBJECTTYPE               CHARACTER(5)                    ,
>     RESPONOBJECTTYPE               CHARACTER(5)                    ,
>     ACCOUNTYPEOID                  DECIMAL(22)                     ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT055TS Index in ENT055IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.ACL_T
> --------------------------------------------------
> Create table ENT01.ACL_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     ACLNAME                        CHARACTER(100)                  ,
>     ACTIVE                         CHARACTER(1)                    ,
>     PREVIOVERSIO                   DECIMAL(22)                     ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT052TS Index in ENT052IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.ACLENTRY_T
> --------------------------------------------------
> Create table ENT01.ACLENTRY_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     GROUPOID                       DECIMAL(22)                     ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT051TS Index in ENT051IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.ADDRES_T
> --------------------------------------------------
> Create table ENT01.ADDRES_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     ADDITIADDRESINFO               VARCHAR(254)                    ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT008TS Index in ENT008IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.ADDRESOTHER_T
> --------------------------------------------------
> Create table ENT01.ADDRESOTHER_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     ADDRESLINE                     VARCHAR(254)                    ,
>     GEOLOCATOID                    DECIMAL(22)                     ,
>     ZIPPLUSFOUR                    CHARACTER(20)                   ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT012TS Index in ENT012IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.AUDIT_T
> --------------------------------------------------
> Create table ENT01.AUDIT_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     TABLENAME                      CHARACTER(5)                    ,
>     ACTVTY                         CHARACTER(5)                    ,
>     SITEADDCHANGE                  DECIMAL(22)                     ,
>     USERADDCHANGE                  DECIMAL(22)                     ,
>     ROWADDED                       TIMESTAMP           NOT NULL    ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         )
> in ENT026TS Index in ENT026IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.CODEVALUE_T
> --------------------------------------------------
> Create table ENT01.CODEVALUE_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     CODETYPE                       CHARACTER(20)                   ,
>     CODE                           CHARACTER(5)                    ,
>     SHORTDESC                      CHARACTER(50)                   ,
>     LONGDESC                       CHARACTER(100)                  ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT017TS Index in ENT017IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.CODEVALUEVERIFY_T
> --------------------------------------------------
> Create table ENT01.CODEVALUEVERIFY_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     CODETYPE                       CHARACTER(20)                   ,
>     CODE                           CHARACTER(5)                    ,
>     SHORTDESC                      CHARACTER(50)                   ,
>     LONGDESC                       CHARACTER(100)                  ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     VERIFYBY                       DECIMAL(22)                     ,
>     VERIFYDATE                     TIMESTAMP                       ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT011TS Index in ENT011IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.DATE_T
> --------------------------------------------------
> Create table ENT01.DATE_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     DATE                           DATE                            ,
>     TIME                           TIME                            ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT013TS Index in ENT013IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.DISCREVALIDA_T
> --------------------------------------------------
> Create table ENT01.DISCREVALIDA_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     VALIDATNAME                    CHARACTER(50)                   ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT023TS Index in ENT023IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.EMAIL_T
> --------------------------------------------------
> Create table ENT01.EMAIL_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     EMAILADDRES                    CHARACTER(50)                   ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT005TS Index in ENT005IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.FOLLOWUP_T
> --------------------------------------------------
> Create table ENT01.FOLLOWUP_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     FOLLOWUPDATE                   DATE                            ,
>     FOLLOWUPDONE                   CHARACTER(1)                    ,
>     FOLLOWUPSCHEDU                 CHARACTER(1)                    ,
>     REASON                         CHARACTER(5)                    ,
>     COMPLY                         CHARACTER(1)                    ,
>     COMMENT                        VARCHAR(254)                    ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT049TS Index in ENT049IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.GEOGRALOCATI_T
> --------------------------------------------------
> Create table ENT01.GEOGRALOCATI_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     CITY                           DECIMAL(22)                     ,
>     STATE                          DECIMAL(22)                     ,
>     ZIPCODE                        DECIMAL(22)                     ,
>     COUNTY                         DECIMAL(22)                     ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT016TS Index in ENT016IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.GROUP_T
> --------------------------------------------------
> Create table ENT01.GROUP_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     GROUPNAME                      CHARACTER(100)                  ,
>     ACTIVE                         CHARACTER(1)                    ,
>     PREVIOVERSIO                   DECIMAL(22)                     ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT050TS Index in ENT050IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.IDENTI_T
> --------------------------------------------------
> Create table ENT01.IDENTI_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     IDENTI                         CHARACTER(20)                   ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT007TS Index in ENT007IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.INTERNADDRES_T
> --------------------------------------------------
> Create table ENT01.INTERNADDRES_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     MAILCODE                       CHARACTER(20)                   ,
>     ADDRESLINE                     VARCHAR(254)                    ,
>     CITY                           CHARACTER(50)                   ,
>     REGIONDESIGN                   CHARACTER(70)                   ,
>     CONTRY                         CHARACTER(5)                    ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT009TS Index in ENT009IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.LEGALLANDDESC_T
> --------------------------------------------------
> Create table ENT01.LEGALLANDDESC_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     TOWNSHIP                       CHARACTER(10)                   ,
>     RANGE                          CHARACTER(10)                   ,
>     SECTIONUMBER                   INTEGER                         ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT054TS Index in ENT054IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.LOCATO_T
> --------------------------------------------------
> Create table ENT01.LOCATO_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     CODEVALUEOBJECTID              DECIMAL(22)                     ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     COMMENT                        VARCHAR(254)                    ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT004TS Index in ENT004IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.MESSAG_T
> --------------------------------------------------
> Create table ENT01.MESSAG_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     MESSAGTYPE                     DECIMAL(22)                     ,
>     MESSAGCODE                     CHARACTER(8)                    ,
>     SHORTDESC                      CHARACTER(50)                   ,
>     LONGDESC                       CHARACTER(100)                  ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT040TS Index in ENT040IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.NAME_T
> --------------------------------------------------
> Create table ENT01.NAME_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     NAME                           CHARACTER(100)                  ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT002TS Index in ENT002IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.OBJECTRELATE_T
> --------------------------------------------------
> Create table ENT01.OBJECTRELATE_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     OBJECTOWNERID2                 DECIMAL(22)                     ,
>     OBJECTTYPERELATE               CHARACTER(5)                    ,
>     RELATETYPEID                   DECIMAL(22)                     ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT018TS Index in ENT018IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.OBJECTSEQUENNUM_T
> --------------------------------------------------
> Create table ENT01.OBJECTSEQUENNUM_T (
>     SEQUENNUMBER                   INTEGER                         )
> in ENT039TS Index in ENT039IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.OBSERVCOMPOS_T
> --------------------------------------------------
> Create table ENT01.OBSERVCOMPOS_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     RECORDDATE                     TIMESTAMP                       ,
>     OBSERVDATE                     TIMESTAMP                       ,
>     COMMENT                        VARCHAR(254)                    ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     OBSERVTYPEID                   DECIMAL(22)                     ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT020TS Index in ENT020IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.OBSERVDEFAUL_T
> --------------------------------------------------
> Create table ENT01.OBSERVDEFAUL_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     DEFAULVALUE                    DECIMAL(10,3)                   ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT045TS Index in ENT045IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.OBSERVPRIMIT_T
> --------------------------------------------------
> Create table ENT01.OBSERVPRIMIT_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     RECORDDATE                     TIMESTAMP                       ,
>     OBSERVDATE                     TIMESTAMP                       ,
>     COMMENT                        VARCHAR(254)                    ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     QUANTI                         DECIMAL(10,3)                   ,
>     UNITOFMEASUR                   CHARACTER(5)                    ,
>     OBSERVTYPEID                   DECIMAL(22)                     ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT021TS Index in ENT021IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.OBSERVTEXT_T
> --------------------------------------------------
> Create table ENT01.OBSERVTEXT_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     OBSERVTEXT                     VARCHAR(254)                    ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT043TS Index in ENT043IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.OBSERVTYPE_T
> --------------------------------------------------
> Create table ENT01.OBSERVTYPE_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     PHENOMNAME                     CHARACTER(50)                   ,
>     MULTIVALUE                     CHARACTER(1)                    ,
>     VALIDAOID                      DECIMAL(22)                     ,
>     VALIDAOBJECTTYPE               CHARACTER(5)                    ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT022TS Index in ENT022IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.PARTY_T
> --------------------------------------------------
> Create table ENT01.PARTY_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT001TS Index in ENT001IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.PASSWO_T
> --------------------------------------------------
> Create table ENT01.PASSWO_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     PASSWO                         CHARACTER(20)                   ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT053TS Index in ENT053IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.PERSONNAME_T
> --------------------------------------------------
> Create table ENT01.PERSONNAME_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     TITLE                          CHARACTER(5)                    ,
>     FIRSTNAME                      CHARACTER(20)                   ,
>     MIDDLENAME                     CHARACTER(20)                   ,
>     SUFFIX                         CHARACTER(5)                    ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT003TS Index in ENT003IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.PHONE_T
> --------------------------------------------------
> Create table ENT01.PHONE_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     EQUIPMTYPE                     CHARACTER(5)                    ,
>     CONTRY                         CHARACTER(5)                    ,
>     AREACODE                       CHARACTER(5)                    ,
>     PREFIX                         CHARACTER(3)                    ,
>     SUFFIX                         CHARACTER(4)                    ,
>     EXTENS                         CHARACTER(10)                   ,
>     INTERNPHONE                    CHARACTER(10)                   ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT006TS Index in ENT006IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.PROPER_T
> --------------------------------------------------
> Create table ENT01.PROPER_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     PROPERNAME                     CHARACTER(100)                  ,
>     PROPERVALUE                    CHARACTER(50)                   ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT044TS Index in ENT044IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.RANGEVALIDA_T
> --------------------------------------------------
> Create table ENT01.RANGEVALIDA_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     VALIDATNAME                    CHARACTER(50)                   ,
>     VALIDUNIT                      CHARACTER(5)                    ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT024TS Index in ENT024IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.RATE_T
> --------------------------------------------------
> Create table ENT01.RATE_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     RATETYPE                       CHARACTER(5)                    ,
>     RATEAMOUNT                     DECIMAL(9,2)                    ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT047TS Index in ENT047IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.REFUGE_T
> --------------------------------------------------
> Create table ENT01.REFUGE_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     ARRIVEDATE                     DATE                            ,
>     ORIGINCONTRY                   CHARACTER(5)                    ,
>     FIRSTPLACEMSITE                CHARACTER(50)                   ,
>     REFUGETYPE                     CHARACTER(5)                    ,
>     ACCOMPMINOR                    CHARACTER(1)                    ,
>     PREGNANT                       CHARACTER(1)                    ,
>     COMMENT                        VARCHAR(254)                    ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT046TS Index in ENT046IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.REPLICLOG_T
> --------------------------------------------------
> Create table ENT01.REPLICLOG_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     SITEREPLICNUMBER               INTEGER                         ,
>     SITEREPLICNEWNUM               INTEGER                         ,
>     LASTREPLICNUMBER               INTEGER                         ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT014TS Index in ENT014IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.REPLICSEQUENNUM_T
> --------------------------------------------------
> Create table ENT01.REPLICSEQUENNUM_T (
>     SEQUENNUMBER                   INTEGER                         )
> in ENT042TS Index in ENT042IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.ROLE_T
> --------------------------------------------------
> Create table ENT01.ROLE_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     ROLENAME                       CHARACTER(50)                   ,
>     DESCRI                         VARCHAR(254)                    ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT041TS Index in ENT041IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.SECURILOG_T
> --------------------------------------------------
> Create table ENT01.SECURILOG_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     ATTEMPUSERNAME                 CHARACTER(20)                   ,
>     ATTEMPPASSWO                   CHARACTER(20)                   ,
>     RECORDDATE                     TIMESTAMP                       ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT033TS Index in ENT033IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.SECURIPOLICY_T
> --------------------------------------------------
> Create table ENT01.SECURIPOLICY_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     MINPASSLENGTH                  INTEGER                         ,
>     MAXNUMTRIES                    INTEGER                         ,
>     PASSWOEXPIRE                   INTEGER                         ,
>     TIMEOUT                        INTEGER                         ,
>     PASSWORETENT                   INTEGER                         ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT032TS Index in ENT032IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.SECURIPRINCI_T
> --------------------------------------------------
> Create table ENT01.SECURIPRINCI_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     USERNAME                       CHARACTER(20)                   ,
>     BEGINDATE                      TIMESTAMP                       ,
>     ENDDATE                        TIMESTAMP                       ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     PASSWOLASTCHANGE               TIMESTAMP                       ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT019TS Index in ENT019IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.SERVIC_T
> --------------------------------------------------
> Create table ENT01.SERVIC_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     SERVICDATE                     DATE                            ,
>     SERVICRATEOID                  DECIMAL(22)                     ,
>     SERVICSITEOID                  DECIMAL(22)                     ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT048TS Index in ENT048IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.SITE_T
> --------------------------------------------------
> Create table ENT01.SITE_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     SITEKEY                        CHARACTER(16)                   ,
>     DBIDENTI                       INTEGER                         ,
>     VOICERESPONPIN                 SMALLINT                        ,
>     LASTREPLICNUMBER               INTEGER                         ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT038TS Index in ENT038IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.STREETADDRES_T
> --------------------------------------------------
> Create table ENT01.STREETADDRES_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     HOUSENUMBER                    CHARACTER(10)                   ,
>     STREETPREDIRECT                CHARACTER(5)                    ,
>     STREETNAME                     CHARACTER(70)                   ,
>     STREETPOSTDIRECT               CHARACTER(5)                    ,
>     SECONDUNITINDICA               CHARACTER(5)                    ,
>     SECONDUNITNUMBER               CHARACTER(10)                   ,
>     STREETSUFFIXABBR               CHARACTER(5)                    ,
>     GEOLOCATOID                    DECIMAL(22)                     ,
>     ZIPPLUSFOUR                    CHARACTER(20)                   ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT010TS Index in ENT010IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.TYPE_T
> --------------------------------------------------
> Create table ENT01.TYPE_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     DESCTYPE                       CHARACTER(20)                   ,
>     CODE                           CHARACTER(5)                    ,
>     DESCRI                         CHARACTER(50)                   ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT036TS Index in ENT036IS  ;
> 
> 
> --------------------------------------------------
> -- Create Table ENT01.VALIDRANGES_T
> --------------------------------------------------
> Create table ENT01.VALIDRANGES_T (
>     OBJECTID                       DECIMAL(22)         NOT NULL    ,
>     OBJECTOWNERID                  DECIMAL(22)                     ,
>     LOWVALUE                       DECIMAL(10,3)                   ,
>     HIGHVALUE                      DECIMAL(10,3)                   ,
>     INCLUDEHIGH                    CHARACTER(1)                    ,
>     INCLUDELOW                     CHARACTER(1)                    ,
>     OBJECTTYPE                     CHARACTER(5)                    ,
>     ACL                            DECIMAL(22)                     ,
>     REPLICNUMBER                   INTEGER                         ,
>     ROWLASTCHANGE                  TIMESTAMP           NOT NULL    )
> in ENT025TS Index in ENT025IS  ;
0
Salad
5/14/2010 7:17:34 PM
Reply:

Similar Artilces:

Import MS Office Excel Comma Separated Values Files into a MS Access 2003 database
Hi, I have been tasked with Importing MS Office Excel Comma Separated Values Files into a MS Access 2003 database. These files were exported from a DB2 database.I have also been given the DDL code. I have Googled a solution to this task and have tried creating these tables using the DDL code in a query within a blank MS Access database. Is there a more expedient way to achieve this? I noticed, for example, that a field in DB2 has a data type of "decimal" while the same field would have the data type of "number". Thanks, Zuf What follows is the DDL: -------...

Create MS/ACCESS database app for non-ms/access users
Is it possible to create an MS/ACCESS database application and package it for users who do not have MS/ACCESS loaded in their PCs? I was told that this is possible, but I don't know what software is needed. Do you know? If so, please answer this post. Thanks. SueB *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Per Sue Bricker: >Is it possible to create an MS/ACCESS database application and package >it for users who do not have MS/ACCESS loaded in their PCs? > >I was told that this is possible, but...

Running a ms access database with access 2003 in Vista
I have a Database that I am trying to run on a new vista computer. Up to now I was running it on a win 98 computer and using access 2003! I installed access 2003 and I can make it run and view the data but I can not save any new records. Has any one seen this problem yet? Thanks Clarence Wollman On Wed, 22 Aug 2007 13:17:13 -0700, cwoll <clarencewollman@gmail.com> wrote: Do you have the same problem with the Northwind sample application? (search your computer for northwind.mdb) -Tom. >I have a Database that I am trying to run on a new vista computer. Up >to now I was running...

Date picker from MS-Access 2000 to MS-Access 2003
Hello. How do I get a date picker (References: Microsoft Calendar Control 8.0 Location C:\Windows\System 32\mscal.ocx) inset in MS-Access 2000, to work in MS-Access 2003. TIA J�rn Why not scrap it and use the all-API approach Stephen Lebans has at http://www.lebans.com/monthcalendar.htm -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "JHB" <joern_bea@removeThis_tdcadsl.dk> wrote in message news:42190d18$0$48635$edfadb0f@dread15.news.tele.dk... > Hello. > > > > How do I get a date picker (References: Microsoft Cal...

MS Access database with a file extension of .mde
Good day: Can you kindly assist me in opening a MS Access database with a file extension of .mde? I get an error message stating "This database is in an unrecognized format". Any help is greatfull. TIA This usually indicates an attempt to open an Access 2000 database in an earlier version. -- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies This posting is provided "AS IS" with no warranties, and confers no rights. "mary" <chloemelmom@yahoo.com> wrote in message news:a0a64947.0311151242.4df0c...

Any MS Access that is NOT MS Access in WinXP?
Hi all, I have a small application for bookkeeping, actually working in Access with small routines in VBA. I want to rewrite it in Java, but I don't want to use Access anymore. I started looking for another database, but I found none. I already know (and used) MySQL and PostgreSQL (waiting 7.4), but as far as I know they are only daemon, and under windows they use a lot of memory and CPU time. It's like installing a Ferrari only to cross the road. Maybe an approach with loading the daemon at the start of the program, and quitting it at the end, but I don't know how ...

Database connection to MS Access & MS Foxpro
Hi, When we select new project ,can "MFC AppWizard(exe)" make connection to database ? or only "database project" can make connection to database ? How do i make connection to database(MS Access/Foxpro) and perform sql using MFC Appwizard(exe) with ODBC --CDatabase? Any sample code ? Thanks. CBTan wrote: > Hi, > > When we select new project ,can "MFC AppWizard(exe)" make connection > to database ? or only "database project" can make connection to > database ? > > How do i make connection to database(MS Acce...

Importing data from an Excel spreadsheet into an MS Access database
I need to import data from a spreadsheet that is created new every day into an MS Access database. The data is in a workbook consisting of multiple work sheets. I plan to import using the TransferSpreadsheet method. The name of the spreadsheet will change every day, but the position of the data to be imported will always be the same. Here is my problem: Having never used this method before, I am unsure as to what to put in the Range parameter. The Range is (let's say) B26:L26 in a sheet labeled "TodayData". How would I put that in the Range parameter? Help in VBA only sh...

Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
Hello all Would it be possible to migrate the MS Access 2000 to MS SQL Server 2000? My application is using MS Access 2000 as database and as user interface such as forms. Now, I want to migrate the backend database from MS Access 2000 to MS SQL Server 2000. However, I want to keep the MS Access 2000 interface. Would it be possible? If I migrate the MS Access to SQL Server, would the queries, back-end VBA, macro, tables and forms be affected? Do I need to change the MS Access data type to SQL server supported data type? Which tool I can use to do the migration? Upsizing wizard or exporting...

MS Access Script to import data from external mde database to mdb database
Hi, Does anyone know of a way I can write a script that imports a table from a particular .mde file? I don't seen any obvious way to do it as a macro. Any suggestions if it can be done as a macro or as a written module? My ultimate goal is to have script that clears info out of 1 table in an .mdb file, imports an identically structured table from a .mde file, runs an append query I have in place to copy the data from the imported table to the table in my.mbd file, and then delete the imported table. Any help that could be provided would be greatly appreciated. Best wishes, George Hadl...

How to import a tab delimited text file into MS Access database
Hi, I have the following task to be done in VC++ 6.0. I have a tab delimited text file that needs to be imported into a MS Access table. The table is created and the table structure is defined using DAO methods. So now I have to fill this table with the data in the text files. For a few rows in the text file, the number of columns could be less than the number of columns in the table. Can anyone please post me the code to do this. Thanks a ton in advance. Pradeep wrote: > I have the following task to be done in VC++ 6.0. We'd be happy to give you the VBA code, but do you really want ...

how to access data iin a MS Excel file using database components?
Can we read data in columns from an MS Excel file? It is possible to use the usual database components in the Delphi palete to read data in an excel file? but how? ...

How to connect a remote MS Access/MS SQL Database from JSP on Linux?
I want to use JDBC to connect a remote MS Access/MS SQL database, however, I found that JDBC-ODBC is not support on remote database and Linux. I've visit the site of some middleware, like RmiJdbc, IDS,.... However, seems don't know how to make it functions and difficult to configure. Do anyone can give me a solution? Thanks Vincent ...

how to export from ms access into ms excel?
I need to export to a particular excel worksheet, but I am unable to specify a range? Is there another way???? Please help...? Nettie ...

Web resources about - Importing MS Office Excel Comma Separated Values Files into a MS Access 2003 database - comp.databases.ms-access

Facebook Expands Feed Connect (er, Feed Importing) to More Sites
About six weeks ago, Facebook launched Feed Importing for the first time, allowing users to connect their Facebook accounts to Flickr, Yelp, ...

YouTube - iPad importing photos from floppy disk.
You are using an outdated browser, which YouTube no longer supports. Since some features on YouTube may not work, you are viewing a lightweight ...

Thousands sign petition urging an end importing of primates for medical research
... inquiry has revealed horrific practices in the name of medical research. A petition with more than 14,000 signatures calling for a ban on importing ...

Importing fuel will prove better for the consumer
Importing fuel will prove better for the consumer

Former supervisor at Victoria's desalination plant jailed for importing marketable quantity of cocaine ...
A former supervisor at Victoria's $4 billion desalination plant who&nbsp;snorted cocaine he imported from Mexico to feed his habit and sell,&nbsp;cope ...

Importing nannies is not the right solution for Australia's childcare crisis
Migrant domestic workers: is that the answer for Australia or is it exploitation?

Mark Clermont sentenced to life in jail for importing drugs worth $260 million inside road roller
A judge has praised police for preventing cocaine and methylamphetamine with a street value of $260 million reaching the streets of Sydney and ...

Hong Kong man charged with importing 150kg of crystal methamphetamine into Sydney
A Hong Kong national is charged with importing 150 kilograms of ice following a joint-agency investigation in Sydney.

Man, 91, charged with importing cocaine hidden in soap boxes into Australia
A 91-year-old Sydney man has been charged with importing cocaine hidden in soap into Australia, prompting police to warn travellers to beware ...

Adobe updates Photoshop Express for Android with blemish removal tool, RAW importing, more
Adobe has actively been rolling out new and powerful tools for mobile platforms in recent months including Lightroom Mobile for iPad followed ...

Resources last updated: 2/5/2016 12:43:18 PM