Subject Same Error
Author Mike Grover
I am getting the same error before if my external file is
over 2 gig?

Import ran about 15 minutes then Errored out.

any Ideas?

Error is below:

I/O error for file "W:\PART1.SDF"
Error while trying to open file
The device does not recognize the command.

Statement: INSERT INTO EXPERIAN
SELECT
"STATE",
"ZIP",
"ZIP4",
"DP",
"CART",
"CITY",
"USPS_HSE_",
"USPS_PREDI",
"USPS_ST_NM",
"USPS_SUFFI",
"USPS_PSTDI",
"UNITDESGN",
"UNTDESGNUM",
"NUMUNITS",
"ADDRUSAGEC",
"ADDRESSQLT",
"COUNTY_COD",
"COUNTYNAME",
"LATITUDE",
"LONGITUDE",
"PHONE",
"HOMEOWNER",
"PROBHOMEOW",
"HO_PROBABL",
"ESTINCOME",
"LOR",
"ESTAGEPDM",
"PERSON1PID",
"PERSON1TYP",
"FIRST_NAME",
"MIDDLE_INT",
"LAST_NAME",
"SUFFIX1",
"TITLE",
"ETHNIC1",
"GENDER1",
"DOB1",
"ESTAGE1",
"AGE1",
"EDUCATION1",
"MARITAL1",
"OCCU1",
"PID2",
"TYPE2",
"FIRST2",
"MI2",
"LAST2",
"SUFFIX2",
"TITLE2",
"ETHNIC2",
"GENDER2",
"DOB2",
"ESTAGE2",
"AGE2",
"EDUCATION2",
"MARITAL2",
"OCCU2",
"CHILDREN",
"HOMEPRICE",
"HOMEPURDAT",
"YR_BUILT",
"HOMEINDICA",
"MOSAICTYPE",
"MOSAICGROU",
"MOSAICGLOB",
"ESTHOMEVAL",
"MARITAL_ST",
"NOMAIL"
FROM EXP