I was wondering if any one could check out this create table script. I have extracted data from a clipper db using an outside application and the application has constructed a script to both build and populate a SQL table within a DB I have created. This is for a SQL2000 database.There error message I receive is:[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax errorHere is a sample of the script:// CREATE TABLE "SQL-Arch2.sql" ( CPR_KEY Character(9), OLD_CPR Character(7), CE Character(3), SE Character(3), PL Character(3), CPR_DATE Date, UPDTLAST Date, UPDTUSER Character(8), STATCHGD Date, STATUSER Character(8), STATUS Character(9), NOTIFY Boolean, COMPANY Character(30), CONTACT Character(30), SITE Character(15), PHONE Character(14), EXTENSION Character(5), FAX Character(14), PTFLEVEL Character(13), MVSRELEASE Character(5), PRIORITY Character(1), SEVERITY Character(1), BATCH_ENV Boolean, IMS_ENV Boolean, CICS_ENV Boolean, IDMS_ENV Boolean, DB2_ENV Boolean, ADAB_ENV Boolean, NATL_ENV Boolean, OTHER_ENV Boolean, IMS_REL Character(5), CICS_REL Character(5), IDMS_REL Character(5), DB2_REL Character(5), ADAB_REL Character(5), NATL_REL Character(5), OTHER_REL Character(20), PROB_SHORT Character(40), PROB_COMM Character(25), CLOSED Boolean, PCR_NO Character(4), PTR_NO Character(6), PTF_NO Character(6), NEEDSCALL Boolean, CVLOG Boolean, PROFILE Boolean, DSPY Boolean, SYSXDUMP Boolean, SAMDSN Boolean, OTHERDOC Character(15), DOCREQSTD Date, DOCRECVD Date, STROBEREL Character(4), APMLEVEL Character(3), EFDLEVEL Character(6), OS2RELEASE Character(3), CMRELEASE Character(3), DBMRELEASE Character(3), APMLIBTYPE Character(1), APMLOG Boolean, GFFILE Boolean, UPDTNEXT Date, SQLAF Boolean, MULTI_USER Boolean, OS Character(8), CM Character(10), DB Character(8), MVSOS Character(6), NEXTUPDATE Date, PRODUCT Character(8) );insert into "SQL-Arch2.sql" (CPR_KEY, OLD_CPR, CE, SE, PL, CPR_DATE, UPDTLAST, UPDTUSER, STATCHGD, STATUSER, STATUS, NOTIFY, COMPANY, CONTACT, SITE, PHONE, EXTENSION, FAX, PTFLEVEL, MVSRELEASE, PRIORITY, SEVERITY, BATCH_ENV, IMS_ENV, CICS_ENV, IDMS_ENV, DB2_ENV, ADAB_ENV, NATL_ENV, OTHER_ENV, IMS_REL, CICS_REL, IDMS_REL, DB2_REL, ADAB_REL, NATL_REL, OTHER_REL, PROB_SHORT, PROB_COMM, CLOSED, PCR_NO, PTR_NO, PTF_NO, NEEDSCALL, CVLOG, PROFILE, DSPY, SYSXDUMP, SAMDSN, OTHERDOC, DOCREQSTD, DOCRECVD, STROBEREL, APMLEVEL, EFDLEVEL, OS2RELEASE, CMRELEASE, DBMRELEASE, APMLIBTYPE, APMLOG, GFFILE, UPDTNEXT, SQLAF, MULTI_USER, OS, CM, DB, MVSOS, NEXTUPDATE, PRODUCT) values ("CS0800146", " ", "ENF", "HDT", "HDT", "1989/10/23", "1998/10/30", "FERGUSON", "1998/10/30", "FERGUSON", "PTR080808", 0, "FIREMAN'S - CA ", " ", " ", " ", " ", " ", " / ", " ", "2", "F", 0, 0, 0, 0, 0, 0, 0, 0, " ", " ", " ", " ", " ", " ", " ", "STRETCH TIME HIGH ", "CPR EXPIRED ", 1, " ", " 808", " ", 0, 0, 0, 0, 0, 0, " ", " ", " ", " ", " ", " ", " ", " ", " ", " ", 0, 0, " ", 0, 0, " ", " ", " ", "MVS ", " ", " ");insert into "SQL-Arch2.sql" (CPR_KEY, OLD_CPR, CE, SE, PL, CPR_DATE, UPDTLAST, UPDTUSER, STATCHGD, STATUSER, STATUS, NOTIFY, COMPANY, CONTACT, SITE, PHONE, EXTENSION, FAX, PTFLEVEL, MVSRELEASE, PRIORITY, SEVERITY, BATCH_ENV, IMS_ENV, CICS_ENV, IDMS_ENV, DB2_ENV, ADAB_ENV, NATL_ENV, OTHER_ENV, IMS_REL, CICS_REL, IDMS_REL, DB2_REL, ADAB_REL, NATL_REL, OTHER_REL, PROB_SHORT, PROB_COMM, CLOSED, PCR_NO, PTR_NO, PTF_NO, NEEDSCALL, CVLOG, PROFILE, DSPY, SYSXDUMP, SAMDSN, OTHERDOC, DOCREQSTD, DOCRECVD, STROBEREL, APMLEVEL, EFDLEVEL, OS2RELEASE, CMRELEASE, DBMRELEASE, APMLIBTYPE, APMLOG, GFFILE, UPDTNEXT, SQLAF, MULTI_USER, OS, CM, DB, MVSOS, NEXTUPDATE, PRODUCT) values ("CS0800147", " ", "ESW", "HDT", "HDT", "1989/10/23", "1998/10/30", "FERGUSON", "1998/10/30", "FERGUSON", "PTR080808", 0, "FIREMAN'S - CA ", " ", " ", " ", " ", " ", " / ", " ", "2", "F", 0, 1, 0, 0, 0, 0, 0, 0, " ", " ", " ", " ", " ", " ", " ", "STRETCH TIME HIGH IMS BMP JOB ", "CPR EXPIRED ", 1, " ", " 808", " ", 0, 0, 0, 0, 0, 0, " ", " ", " ", " ", " ", " ", " ", " ", " ", " ", 0, 0, " ", 0, 0, " ", " ", " ", "MVS ", " ", " ");I appreciate any help you can provide.Sincerely,Tim 
Create Table Script for SQL2000
Posted - 2002-01-14 : 10:29:20
