f



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 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:40:28 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

0 Replies
6587 Views

Similar Articles

[PageSpeed] 36

Reply:

Similar Artilces:

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 i...

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 - Import MS Office Excel Comma Separated Values Files into a MS Access 2003 database - comp.databases.ms-access

Separated by Motorways - Wikipedia, the free encyclopedia
" Separated By Motorways " was a 7" only release by Sheffield band The Long Blondes . It was released on December 12, 2005, on Paul Epworth's ...

Rush Hour on the Dunsmuir Separated Bike Lane - Flickr - Photo Sharing!
Vancouver's separated bike lanes have significantly increased bike ridership. Studies show that a most people are interested in cycling, but ...

Ben Carson: I'm the only here who has separated Siamese twins. - YouTube
From the Fox News Republican debate, August 6, 2015.

Asylum seeker separated from her sick newborn in Brisbane
An asylum seeker who was moved off Nauru to give birth is being locked up for 18 hours a day in a detention centre in Brisbane while her week-old ...

Children stuck in middle as separated parents fight over schools
It's an issue that regularly crops up - separated parents fighting over schools. But what happens to the children caught in the middle?

You gotta keep ‘em separated: Google not merging Chrome OS and Android
Google has announced that it intends to keep its Chrome OS and Android platforms separate, despite the two platforms now being managed by the ...

Rory McIlroy and Adam Scott to be separated in Australian Open draw
... the world's top two golfers apart until the weekend. "It's for the exact reasons that the Masters, US and British Opens and the US PGA separated ...

Hunger striker 'separated from brother'
An asylum seeker hospitalised in Perth after a prolonged hunger strike may have refused water after being separated from his brother, advocates ...

Australian Troops Separated from ANA After Green-on-Blue Attacks
Australian troops in Afghanistan have been physically separated from the Afghan National Army to protect the Diggers from their allies after ...

We're separated, should investment property go?
Sometimes with more than one property it's hard to see which is best to rent out and which is best to live in. Q. My wife and I separated two ...

Resources last updated: 2/13/2016 12:49:44 AM