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

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:44:05 PM
access.queries 6343 articles. 1 followers. Follow

1 Replies
746 Views

Similar Articles

[PageSpeed] 59

Access 2003 has a Table Import wizard that will walk you through importing 
the data into your table.  If you right-click in the white space on your 
Database Window (assuming you have selected the "tables" tab, you would 
select Import on the shortcut menu.  You can then select the file type and 
open the file, and it will walk you through importing it.

-- 
Amy E. Baggott

"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson


"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
> 
> 
> 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
0
Utf
5/14/2010 7:38:14 PM
Reply:

Similar Artilces:

Linking files 2 ways
I have a work book that is linked to another and vise versa. As thus: Workbook A is where the input of data is made; Workbook B has a link to the input from workbook A; Workbook A retrieves the altered data back as a link. Although this all works fine with both books open, I note that if I open workbook A by itself, that the data it retrieves from Workbook B is not updated . If However, both books are open, there's no problem. I thought linked books were updated automatically if the Update remote references has been selected?? But it appears that the second book is not updated until it ...

Merging Two Office Data Files
This is a multi-part message in MIME format. ------=_NextPart_000_0038_01C3C6E7.505DB790 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Here is the situation: I've a desktop and a laptop. Before I bought the laptop I was using MS = Outlook on my desktop. Now that I'm using my laptop mostly, I would like = to have my old emails from my desktop Outlook merged with the laptop = Outlook emails. I don't want to replace the laptop outlook files with = the desktop outlook files is the folder - C:\Documents and = Settings\Laptop\Lo...

OL2007 not move big files from outbox to sent
Hi, We have 2 computers with separate email accounts on Roadrunner. One machine has XP with Outlook 2002-sp3 and works without any problems. The other has Outlook 2007 on Vista and has problems sending files over a meg or so in size. It seems to actually send the file but the file remains in the outbox folder and does not move it to the sent folder. I say it "seems" to send the file because some people complain of getting muliple copies and others don't seem to get them at all. If I hit send again (not set up for auto send) it seems to send the file again (why some ...

Purchased Office 5-19--Upgrades Available?
This is a retail, boxed copy of Office delivered 5-19. Is there any way = to=20 upgrade to Office 2004 short of the $239 (or whatever it was)? Thanks. anonymous@discussions.microsoft.com wrote : > This is a retail, boxed copy of Office delivered 5-19. Is there any way to > upgrade to Office 2004 short of the $239 (or whatever it was)? Thanks. Yes! Se here: http://www.microsoft.com/mac/default.aspx?pid=office2004tg --------------------------------------------------------- Please reply to the newsgroup, and within the same thread. Merci de r�pondre au groupe, et dans l'enfilade...

Excel button problem
Hi All I have a macro that copies a worksheet in the active workbook and puts it into a new workbook - then formats it and deletes any buttons on the worksheet. On the first click on the button the macro works ok. On the second click, it fails because the all assigned macros on all buttons in the active workbook changed from "mba" to "book1!mba". Book 1 doesn't exists (wasn't opened, wasn't saved, doesn't have the macros). I've never experienced this problem before?? Can anyone help to solve this problem? FYI The macro to do this is c...

Excel 97 #9
Please can anyone help??? I have two columns in Excel 97. The first contains a list of statu values eg. pending, or granted or withdrawn. The second contains date eg.01/12/1997, 05/06/2003. I woudl like to know how to get all th granted apps before 31/12/2003. Can anyone help please -- Message posted from http://www.ExcelForum.com theres many ways, but an easiest way would be to do a sort. Highlight the 2 columns, click on data, then sort, then sort by status, then by date. this should group them all together. hope this helps...toe >-----Original Message----- >Please can anyo...

Using Relative path for XML data file?
Is there a way to specify a relative path to an XML data file imported into Excel 2003? I am writing a web app that generates report data as XML for the user to download to their local machine. This data is to be consumed by an Excel reporting spreadsheet, which contains display-formatted tables and charts that are mapped to various data fields in an XML Map, which is in turn linked to the xml data file they will download. The idea is the user only needs to download the data for updates, not the whole spreadsheet. However, since I cannot predict the path where the user will store their...

From Outlook 2000 to Outllook 2003
How do I migrate I personal folders file (.pst) from Outlook 2000 to Outlook 2003? Read the Help Files: http://office.microsoft.com/en-us/assistance/HA010771141033.aspx -- Russ Valentine [MVP-Outlook] "rolo" <rolo@discussions.microsoft.com> wrote in message news:706405A0-2971-409F-B213-67714B12713C@microsoft.com... > How do I migrate I personal folders file (.pst) from Outlook 2000 to > Outlook > 2003? Thanks Russ it helped. By the way how can I get to this useful help files? "Russ Valentine [MVP-Outlook]" wrote: > Read the Help Files: > htt...

How to repair a .dll file in IE8
Several days ago I noticed in my Dependency Walker that the IESHIMS.dll files has a yellow circle with a question mark on it. What does this mean and How do I repair it? OS: Windows Vista Home Premium Browser Internet Explorer 8 -- TW Hi, See the History tab on that dialog. A web search for ieshims.dll files will also help you find a solution for that file. Regards. "TW" <TW@discussions.microsoft.com> wrote in message news:63E61463-D766-4ABC-B081-BFA8C04FB159@microsoft.com... > Several days ago I noticed in my Dependency Walker that the IESHIMS....

unsolicited entry in the folder "Temporary Internet Files"
Hello, I am working on a programme which browses web sites and runs under XP. The http download is as follows: pServer = Isession -> GetHttpConnection(strServerName, nPort); pFile = pServer->OpenRequest(CHttpConnection::HTTP_VERB_GET, strObject, NULL, 1, NULL, NULL, dwHttpRequestFlags); pFile->SendRequest(); pFile->QueryInfoStatusCode(dwStatusCode); if(dwStatusCode == 200) { pFile -> QueryInfo(HTTP_QUERY_LAST_MODIFIED, &sysT); status.lastMod = sysT; if(DBlastMod == status.lastMod) //URL content has not changed since the last visit ...

New to excel
Hi All, I'm new to Excel ( and to this forum :) ) and so I hope somebody may b able to help me. I've got 2 questions.... QUESTION 1 I've got a spreadsheet which takes data from one worksheet and uses i to calculate data in a second worksheet using the following code formula: =IF('4th November 2005'!B19="","nothing here dude",IF(B19<'4th Novembe 2005'!B19,"UP",IF(B19='4th November 2005'!B19,"Same",IF(B19>'4t November 2005'!B19,"DOWN")))) The problem is, when I create a new worksheet I have...

Reporting from Project Server
I dont know if i need to ask this question here or in the Access section. I have an ODBC connection to the Project Server database so I can make reports through Access. Access' limit of 255 fields per table is causing me some trouble. for example, the MSP_VIEW_PROJ_PROJECTS_ENT table has well over 255 fields. Access only shows me the first 255 fields. how can I change that so I can see all the fields in that table? thanks, Hadi Hadi, I have not tried this yet it may be a viable option. Have your DBA create a view that pulls the key fields to this table and the specifi...

Looking for Excel Help
I'm a very novice Excel user and am looking for a little help with creating a formula for a spreadsheet I'm creating for my personal use. I would appreciate some assistance if possible. Thanks in advance. Dan --- Message posted from http://www.ExcelForum.com/ Hi Dan! Post a sample of what you want to do. Your question is just a tad open ended <g> -- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "DanB4105" <DanB4105.ywtpa@excelfor...

Maximum file sizes
Is there a recommended maximum file size for Excel 2000. PC spec 2Ghz P4 with 256 Mb Any advice appreciated Deus -------------- Does Not Exist Hi have a look at http://www.decisionmodels.com/memlimits.htm -- Regards Frank Kabel Frankfurt, Germany "Deus DNE" <deus.dne@ntlworld.com> schrieb im Newsbeitrag news:1561701c41d4f$358950f0$a001280a@phx.gbl... > Is there a recommended maximum file size for Excel 2000. > > PC spec 2Ghz P4 with 256 Mb > > Any advice appreciated > > Deus > -------------- > Does Not Exist ...

File size #11
I have read the other discussions on file sizes but they do not seem to address my problem. I have an Excel file that is 12mb large with low-res jpegs in it. This file also has merged cells to make it look pretty. Does Excel look at these merged cells as graphics? Is this why they are too big? I have run a macro to make sure that it goes to the last cell. How can I get the file smaller? How big are the graphics? If you remove them from the file, what is the size of the file and what is the size of the graphic files? To be sure you do not have extra formatting, if you open the file...

Unable to delete empty database
I recently moved a group of users out of one database into another Database within the same storage group. After successfully moving all users (except SMTP and SystemMailbox) out of the 1st database I attempted to delete the database only to receive an error: One or more users currently use this mailbox store. These users must be moved to a different mailbox store or be mail disabled before deleting this store. Id no: c1034a7f Exchange System Manager Can I delete this mailbox via ADSIEDIT? Is this the recommended alternative? Thanks, BJ Use the AD Users and Computers snap-in ...

Excel corrupts when asking to update vlookups
We are experiencing weird behavior with some Office 2K3 Excel spreadsheets that contain lots of calculations, but no macros. On some pc’s Excel acts normally, on others you get the error. I have a couple of screen shots available. Any help is appreciated. If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Gu...

Uninstall of mappoint has caused errors with excel
Hi, I am running Office 2003 on the terminal server (windows 2003) and had a copy of mappoint as well. This is a mapping program. We ininstalled mappoint which has caused an error message with Excel and other office products. The error says "Cd:\documents and settings\administrator.ocrdc1\application data\microsoft\addins c:\Program files\common files\microsoft shared\geography\mpoai9.dll is not a valid add-in." I then click OK and excel opens up and everything is fine. The problem is that we are using other programs as well such as Quickbooks that export to excel and t...

Outlook 2003 Drag and Drop Emails
I have an issue where there is a SBS 2003 server (newly installed) & when I drag emails to the file system (explorer window) in order to create file records of the emails it generates an error. Dialog Box Name: Error Copying File or Folder Error Msg: Not enough storage is available to process this command. I can't find an error logged anywhere, either on the server event logs or on the local machine event logs... I have searched the MS KB & Office online, but no joy yet... If anyone can help that would be great!!! R ...

Redirect Exchange 2000 IS backup to different Exchange 2003 server
I recently added an Exchange 2003 server to the same org as a 2000 server. I have dbs from the 2000 server that I need to restore to retrieve email from a user whose mailbox was moved to 2003. So I need to restore the db for that mailbox from BEFORE it was moved because when you move mailboxes you lose any deleted items that were being saved by retention policy. Is this possible? I'm using Veritas Backup Exec 10 but nothing in their support KB seems to follow this exact scenario. If it helps, the old Exch 2000 server is currently empty of users and is ready to be uninstalled. W...

Filters not working in Exchange 2003
I have been trying to turn on the Recipient, Connection, and Sender filters. I have gone to the Default SMTP Virtual Server and turned it on there without getting an error but when I go to the Properties and add senders to block and the hit Apply, it tells me that I must manually turn the filtering on in the SMTP VS. I have stopped and started the Default SMTP VS but still no luck. Any ideas? Hi Wayne That is a standard dialog box, it does not check to see if it is already enabled, have you tested the sender filtering? -- Mark Fugatt Microsoft Limited This posting is provided &quo...

setup Windows Mail as Word 2003 default emailer
All I can do is setup Outlook. I do not use Outlook. I would like to email Word docs using MS Windows Mail (new version of Express) In the Windows Start area, type Regedit into the search bar and then start the Registry Editor and go to HKEY_CURRENT_USER>Software>Clients>Mail Right Click on the (Default) item and then on Modify and in the Value data: field enter Windows Mail so that after you click OK, you have (Default) REG_SZ WIndows Mail -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a pa...

Math Worksheet Database
I am interested in developing/acquiring an Access 2003 database to generate (K-5 grade) math worksheets where I can track student results. I would hope not to reinvent the wheel. Thank you for any assistance. ...

will CRM load on a 2003 server?
will CRM load on a 2003 server? Microsoft CRM v1.2 supports Windows 2000/2003 Server. Frank Lee Workopia, Inc. >> Other Microsoft CRM Online Forum Resources: http://www.workopia.com/Links.htm >-----Original Message----- >will CRM load on a 2003 server? >. > No problem. We just completed a 1.2 installation on a 2003 server, without any problems. Brian Demoe "Troy Hicks" <tlhicks@nc.rr.com> wrote in message news:03dd01c3dcb2$93653a00$a501280a@phx.gbl... > will CRM load on a 2003 server? CRM 1.2 will also load on Small business server 2003 as wel...

unable to paste Excel 2003 chart into Outlook 2003
(This was posted on "excel.charting" group.) I have a user who's unable to paste an Excel 2003 chart into Outlook 2003 email message. In Outlook options, the checkbox is selected for "Use Microsoft Office Word 2003 to edit e-mail messages". When I tested this on my own computer running the same version of Office, if the box is check, I have no problem pasting; if this box is cleared, I cannot paste. But on his computer, it doesn't work regardless. Thanks and regards, TL ...