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

Z

zufie

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 ;
 
A

Amy E. Baggott

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing MS Office Excel Comma Separated Values Files into a MSAccess 2003 database 1
Syntax error in CREATE TABLE statement. (Error 3290) 3
Forward Engineer Visio ER Diagram to SQL DDL 2
Error Linking/Importing Oracle Tables to Access 2003! 0
run stored proc from excel with a parameter 1
Database bloat 2
File upload into database doesn't work 2
Please help (complex query) 8

Top