load data from text file

[irving]

I have a text file that has 250 fields that are comma delimited and are enclosed by quotes. If a field has no value the text file with show ,"", . I am having problems importing into my MySQL table. The empty table has been created. Can anyone help? I have tried changing field values in the table with no success. Since the text file does not have fixed length fields, do this create a problem?

[Anon]

can you show the table schema here please?

[irving]

Here it is:

Table structure for table Mlstest

#

CREATE TABLE Mlstest (
CATEGORYS text NOT NULL,
COLISTAGTNAM text NOT NULL,
DOM text NOT NULL,
LISTAGENTNAME text NOT NULL,
LISTOFFNAME text NOT NULL,
LISTOFFPHONE text NOT NULL,
SOLDAGENTNAME text NOT NULL,
SOLDAGENTPHON text NOT NULL,
SOLDOFFNAME text NOT NULL,
SOLDOFFPHONE text NOT NULL,
AREADESCR text NOT NULL,
PROPTYPEDESCR text NOT NULL,
BASMNTSQFTFIN text NOT NULL,
BR2DIMEN text NOT NULL,
BR2LEVEL text NOT NULL,
BR3DIMEN text NOT NULL,
BR3LEVEL text NOT NULL,
BR4DIMEN text NOT NULL,
BR4LEVEL text NOT NULL,
BR5DIMEN text NOT NULL,
BR5LEVEL text NOT NULL,
DENDIMEN text NOT NULL,
DENLEVEL text NOT NULL,
DINDIMEN text NOT NULL,
DINLEVEL text NOT NULL,
FAMDIMEN text NOT NULL,
FAMLEVEL text NOT NULL,
KITDIMEN text NOT NULL,
KITLEVEL text NOT NULL,
LIVDIMEN text NOT NULL,
LIVLEVEL text NOT NULL,
MBRDIMEN text NOT NULL,
MBRLEVEL text NOT NULL,
OTHROOM1 text NOT NULL,
OTHROOM2 text NOT NULL,
OTH1DIMEN text NOT NULL,
OTH1LEVEL text NOT NULL,
OTH2DIMEN text NOT NULL,
OTH2LEVEL text NOT NULL,
PAROCHSCHCAT1 text NOT NULL,
SQFTCOMNTCAT1 text NOT NULL,
TAXEXEMPCAT1 text NOT NULL,
WATERHAZCAT1 text NOT NULL,
EASEMENTS text NOT NULL,
MINERALRIGHTS text NOT NULL,
NUMLOTS text NOT NULL,
PAROCHSCHCAT2 text NOT NULL,
PASTUREACRES text NOT NULL,
PROPFACES text NOT NULL,
ROADACCESS text NOT NULL,
TAXEXEMPCAT2 text NOT NULL,
TILLABLEACRES text NOT NULL,
TOPOGRAPHY text,
WATERHAZCAT2 text NOT NULL,
WOODEDACRES text NOT NULL,
PAROCHSCHCAT3 text NOT NULL,
RESERVESCAT3 text NOT NULL,
TAXEXEMPCAT3 text NOT NULL,
UNIT1BEDROOMS text NOT NULL,
UNIT1LEASED text NOT NULL,
UNIT1LSEDATE text NOT NULL,
UNIT1OCCUPBY text NOT NULL,
UNIT2BEDROOMS text NOT NULL,
UNIT2LEASED text NOT NULL,
UNIT2LSEDATE text NOT NULL,
UNIT2OCCUPBY text NOT NULL,
WATERHAZCAT3 text NOT NULL,
BUSINESSINCL text NOT NULL,
EXPANDABLE text,
INDUSTRIALSQFT text NOT NULL,
LEASEPRICEPER text NOT NULL,
OFFICESQFT text,
RESERVESCAT4 text NOT NULL,
RESIDENTLSQFT text,
RETAILSQFT text NOT NULL,
TAXEXEMPCAT4 text NOT NULL,
UNIT1DESC text NOT NULL,
UNIT1LSEPER text NOT NULL,
UNIT1NUMUNITS text NOT NULL,
UNIT1VACUNITS text NOT NULL,
UNIT2DESC text,
UNIT2LSEPER text,
UNIT2NUMUNITS text,
UNIT2VACUNITS text,
WAREHOUSESQFT text NOT NULL,
WATERHAZCAT4 text NOT NULL,
FEATURE01 text,
FEATURE02 text,
FEATURE03 text,
FEATURE04 text,
FEATURE05 text,
FEATURE06 text,
FEATURE07 text,
FEATURE08 text,
FEATURE09 text,
FEATURE10 text,
FEATURE11 text,
FEATURE12 text,
FEATURE13 text,
FEATURE14 text,
FEATURE15 text,
FEATURE16 text,
FEATURE17 text,
FEATURE18 text,
FEATURE19 text,
FEATURE20 text,
FEATURE21 text,
FEATURE22 text,
FEATURE23 text,
FEATURE24 text,
FEATURE25 text,
FEATURE26 text,
FEATURE27 text,
ACRES text,
AREACODE text,
ASSOCFEE text,
AVGLEASE text,
BAC text,
BEDROOMS int(11) default NULL,
CATGNUM text,
CEILINGHGHTFT text,
CEILINGHGHTIN text,
CITY text,
COLISTPHONE text,
COLISTORCODE text,
COUNTY text,
CURPRICE text,
CURRENTUSE text,
DIRECTIONS text,
DISCLOSURES text,
DIVISIBLE text,
ELECTRICEXP text,
ELEMSCHOOL text,
EXPDATE text,
FEEINCL text,
FORLEASE text,
FORSALE text,
FOUNDATION text,
FRONTAGE text,
FUELEXP text,
FULLBATHS int(11) default NULL,
GROSSINCOME text,
HALFBATHS int(11) NOT NULL default '0',
HANDICAP text,
HIGHSCHOOL text,
HOASSOC text,
INSURANCEEXP text,
INTRATE text,
LEGALDESC text,
LENDERNAME text,
LISTAGTPHONE text,
LISTDATE text,
LISTAGENT text,
LISTOFFCODE text,
LOCKBOXDESC text,
LOTDIMEN text,
LOTSQFT text,
MAINTEXP text,
MANAGEMENTEXP text,
MAPCOORD text,
MAPPAGE text,
MAXFLOORLOAD text,
MIDDSCHOOL text,
MINDEPOSIT text,
MORTBALANCE text,
MORTPAYMENT text,
MORTTERM text,
MORTTYPE text,
NETINCOME text,
NEWCONSTR text,
NOROOMS text,
NOSTORIES text,
NUMOFDOCKS text,
NUMOFELEVATOR text,
NUMOFFP text,
NUMOFRESTROOM text,
NUMOFTENANTS text,
NUMOFUNITS text,
NUMOVRHDDOORS text,
OCCUPIEDBY text,
OTHBATHS text,
OTHCOMP text,
OTHEREXP text,
OTHRSCHOOL text,
OWNERNAME text,
OWNERPHONE text,
PARCELID text,
PARKING text,
PAYMENTINCL text,
PENDINGDATE text,
PERCENTLEASED text,
PHOTOINSTRUCTN text,
POSSESSION text,
PRICEACRE text,
PROPTYPE text,
SAC text,
SCHOOLDIST text,
SPECIALASSMT text,
SQFT text,
SQFTSOURCE text,
STATE text,
STATUSCODE text,
STATUSFLAG text,
STREETDIR text,
STREETNAME text,
STREETNUM text,
SUBAREA text,
SUBDIVCOMPLEX text,
TAKEPHOTO text,
TAXYEAR text,
TAXES text,
TERMS text,
TOTASSESSDVAL text,
TOTBATHS text,
TOTOPERATEXP text,
TOTSQFT text,
TOWNSHIP text,
TRAFFICCOUNT text,
UNITNUM text,
UNIT1FULLBATH text,
UNIT1PARTBATH text,
UNIT1RENT text,
UNIT1ROOMS text,
UNIT1SQFT text,
UNIT2FULLBATH text NOT NULL,
UNIT2PARTBATH text NOT NULL,
UNIT2RENT text NOT NULL,
UNIT2ROOMS text,
UNIT2SQFT text NOT NULL,
VACANCYFACTOR text NOT NULL,
WARRANTY text NOT NULL,
WATERSEWEREXP text NOT NULL,
WITHDATE text NOT NULL,
YEARBUILT text NOT NULL,
ZIPCODE text NOT NULL,
ZONING text NOT NULL,
REMARKS text NOT NULL,
SELLERCONCESSN text NOT NULL,
SOLDAGENT text NOT NULL,
SOLDDATE text NOT NULL,
SOLDOFFCODE text NOT NULL,
SOLDPRICE text NOT NULL,
SOLDTERMS text NOT NULL,
LISTNUMBER int(11) NOT NULL default '0',
LISTPRICE double NOT NULL default '0',
REMARKS2 text NOT NULL,
REMARKS3 text NOT NULL,
REMARKS4 text NOT NULL,
REMARKS5 text NOT NULL,
OFFMARKETDATE text NOT NULL
) TYPE=MyISAM;

[Anon]

are you trying to put a null value into a field that is specified as "NOT NULL" ?

[irving]

Are you saying I need to make each colunm null with NULL for default value like I have on some of the columns?

[irving]

Are you saying I need to make each colunm null with NULL for default value like I have on some of the columns?

[Anon]

I would take out the "NOT NULL" values unless you specifically need them to be not null.

[irving]

I tried with both as NULL with default "NULL" and "NOT NULL and still have the same problem. It doesn't give me any errors but when I check the table there are no rows.

[irving]

Is there a problem with my column data being all caps?

[irving]

Here are a few lines fo my text file:

"SFM","UNKNOWN","8","WAYDE JONES","GAMMON REALTY","[phone]","","","","","E OF 41 TO WARRICK COUNTY LINE","","","","2","","2","","","","","","","","1","","","","1","","1","","2","MUD RM","","","1","","","","","HE & ME","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","2 STORY","WOOD","SEE REMA","PARTIAL","FRAME","UNKNOWN","GABLE","","","WTRSEWR","EATINKIT","1FIREPL","CARPET,VINYL","OTHER","RANGE,REFRIGER","","PORCH","CHAINLNK","LEVEL,RECTANGL","CHATDRIV","","FIXER UP","","CASH","CL LSTAG","","","","2","","","MG5","3","1","","","EVANSVILLE","","","82","5,000","","WALNUT TO NORTH ON HARLAN EAST ON OLIVE","","","","HOWARD ROOSA","05/15/2002","","","","","","","1","","","","NORTH","","","","CITY KNIGHT-6 KENSINGTON 133 BL 3","","[phone]","02/15/2002","648427","GAMM","COMBO","25 X 135","","","","","","","EVANS","","","","","","","","7","2.0000","","","1","","","","","V","","","","","","","09-290-13-042-025","","","","","I WILL EMAIL PHOTO","IMMED","","R","","","","1760","P","IN","A","","","OLIVE","1314","","","S","2001","27","","8200","1.0000","","1760","KNIGHT","","","","","","","","","","","","","","","","","1900","47714-","","INVESTMENT OPPORTUNITY NEAR THE UNIVERSITY OF EVANSVILLE. AT PRESENT IS A","","","","","","","86015","5,000","SINGLE FAMILY HOME. WOULD BE GREAT TO FIX UP AND RENT OUT AS DORMITORY.","OFF STREET PARKING AVAILABLE","","",""
"LND","UNKNOWN","4","JULIE ROBARDS","F. C. TUCKER EMGE OF NEWBURGH","[phone]","","","","","WARRICK, SPENCER CO, TELL CITY","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","RURAL","","","","","","","COVENANT","","","C PARK,C POOL,C TENNIS,GOLFCRSE,GATEDCOM,CLUBHSE","","","","","","","","","","","","",".0000","3","","","MJ","","2","","","SANTA CLAUS","","","74","5,000","","CHRISTMAS LAKE VILLAGE,R ON MELCHOIR DR N.,L ON KASPER,","","","","LINCOLN TRAIL","08/31/2002","","","","","","","","","","","HERITAGE","","","","X","","[phone]","02/19/2002","63713","FCTE02","","","","","","","","","HERITAGE HILLS","","","","","","","","","","","","","","","","","","","","","","","[phone]","","","","","","","","","L","","","","","","IN","A","","","PRANCER","LOT231","","","N","","","","",".0000","","","CLAY","","","","","","","","","","","","","","","","","","47579-","","BUILD YOUR DREAM HOME ON THIS BEAUTIFUL WOODED LOT IN CHRISTMAS LAKE","","","","","","","86050","5,000","VILLAGE. GREAT LOCATION NEAR THE RECREATION CENTER. BRING ALL OFFERS!","","","",""
"LND","UNKNOWN","175","MARCIA STEARNS","F. C. TUCKER EMGE EASTSIDE","[phone]","","","","","WARRICK, SPENCER CO, TELL CITY","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","NONE","N","1","",".0000","N","","NONE",".0000","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","HOMESITE,WOODED","","PRIVATE","SUBURBAN","","","","TELEPHON","","LEGAL","DEED RST,NO MOBIL,COVENANT","","WALK TO,ACCESS","C PARK,C PLYGRD,C POOL,C TENNIS,GOLFCRSE,GATEDCOM,CLUBHSE","CASH","VACANT","RES LAND","","","","","","","","","",".3000","3","210","","MJ","","2","","","SANTA CLAUS","","","74","6,500","VACANT-POSSIBLE HOMESITE","HWY 62 THU BNVL,AT Y TAKE LEFT RD,STAY ON 62,L ON 231,R ON","","N","","LINCOLN TRAIL","03/31/2002","MAINTENANCE","","","","85","","","","","","HERITAGE HILLS","Y","","","EVERGREEN LOT 125","","","09/01/2001","684944","FCTE05","NONE","85X164","","","","","","","HERITABE HILLS","","","","","","","","","","","","","","","","","V","","MJ","","","","","021-030-00001320","","","","","NO E-BOX - LAND","","","L","","","","","","IN","A","","","EVERGREEN","125","","","Y","2001","51","","2300",".0000","","","CLAY","","","","","","","","","","","","","","N","","","","47579-","R1","PS MAINTENANCE FEE FOR SEWER $18 EVERY QTR.OWNING LOT GIVES ON ACCESS TO A","","","","","","","83339","6,500","GATED COMM.OFFERING BOATING,FISHING,TENNIS,GOLF & SWIMMING.WOODED LOT ABOUT","1/5 OF A MILE FROM CHRISTMAS LAKE. SMALL TREES ON PROP WHICH WOULD BE EASY","TO CLEAR.DIR-AT ENTRANCE R ON MELCHOIR DR N,THEN L ON EVERGREEN LN,L AROUND","CURVE TO EVERGREEN PLAZA TO LOT 125.HIGHEST POINT OF SUB.GOOD HOMESITE.",""
"LND","UNKNOWN","294","ANGIE BARR","ERA FIRST ADVANTAGE REALTY, IN","[phone]","","","","","WARRICK, SPENCER CO, TELL CITY","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","1","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","LAND","","","","RURAL","FINSH GR","","","ELECTRIC","","","","","","","CONVENT,CASH","","RECREAT","","","","","","","","","",".0000","3","","","MJ","","2","","","ROCKPORT","[phone]","JULIE VANDEVEER","74","6,800","","66E S ON 900W (EUREKA EXIT) CONTINUE S 5 MI TO RIVER","","","","LUCE","05/29/2002","","","","","","","","","","","SOUTH SPENCER","","","","LOT 3 BOONVILLE BOAT CLUB","","[phone]","05/05/2001","582564","ADVA","","79X50","","","","","","","SOUTH SPENCER","","","","","","","","","","","","","","","","","","","","","","","","080-060-403300","","","","","U","IMMED","","L","","","","","","IN","A","","","BOONVILLE BOAT CLUB","LOT 3","","","Y","2001","13","","",".0000","","","LUCE","","","","","","","","","","","","","","","","","","47635-","","WATER AND ELECTRIC ON LOT. VACANT LOT READY FOR YOUR OWN PRIVATE GETAWAY.","","","","","","","80798","6,800","#28","","","",""
"LND","UNKNOWN","151","DAVID TALLEY","ERA FIRST ADVANTAGE REALTY, IN","[phone]","","","","","WARRICK, SPENCER CO, TELL CITY","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","OPEN","","PAVED","RURAL","","","","ELC AVL","CITYSEWR,CITY WTR","RCD PLOT","NO MOBIL,COVENANT","","","GATEDCOM","","","RES LAND","","","","","","","","","",".2400","3","","","*","","2","","","SANTA CLAUS","","","74","8,500","","GO THROUGH GATEHOUSE,TURN R ON MELCHOIR,TURN L ON KASPER TO","","","","LINCOLN TRAIL","03/30/2002","","","","","","","","","","","HERITAGE HILLS","","","","LOT 282 HOLLY SHORES IN 5TH SUB","","[phone]","09/25/2001","488291","ADVA","NONE","70X150","","","","","","","HERITAGE HILLS","","","","","","","","","","","","","","","","","","","","","","","","02122000001030","","","","","","IMMED","","L","","","","","","IN","A","","W","HOLLY","827","","CHRISTMAS LAKE","N","","42","","",".0000","","","CLAY","","","","","","","","","","","","","","","","","","47579-","","GATED COMMUNITY AT CHRISTMAS LAKE VILLAGE.GREAT PLACE TO LIVE,CAN PLAY GOLF","","","","","","","83792","8,500","TENNIS AND FISH.ALSO HAS A CALUB HOUSE. #507","","","",""
"SFM","UNKNOWN","51","THOMAS MASON","MIDWEST REAL ESTATE & APPRAISA","[phone]","","","","","GIBSON COUNTY","","","","","","","","","","","","","","","","","","","","","","","","","","","","","EG","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","1.5STORY","AL/VINYL","NONE","FULL,UNFINISH","","","","","","WTRSEWR","","","","","","","PORCH","","CORNER","","","FIXER UP","","","CL LSTOF","","","","6","","","MJ","3","1","","","OAKLAND CITY","","","26","8,500","","HWY 57 LEFT ON MAIN, RIGHT ON COLUMBIA TO LINCOLN","","","","EG","03/31/2002","","","","","","","1","","1","","EG","","","","HARGROVE ADD 62PT","","[phone]","01/03/2002","682951","MWRE","NO","50X70","","","","","","","EG","","","","","","","","5","1.5000","","","","","","","","","","","","","","","0160028900","","","","","","IMMED","","R","","EG","","1487","P","IN","A","","N","LINCOLN","110","","","N","2001","","","","1.1000","","1487","COLUMBIA","","","","","","","","","","","","","","","","","1920","47660-","","THIS HOME IS IN NEED OF REPAIRS, REPO-ADDENDUM TO PURCHASE AGREEMENT NEEDS","","","","","","","85577","8,500","TO BE SIGNED AT TIME OF OFFER.","","","",""
"SFM","UNKNOWN","8","TIM MASON","MIDWEST REAL ESTATE & APPRAISA","[phone]","","","","","GIBSON COUNTY","","","14X10","","","","","","","","","","14X11","","","","15X11","","17X12","","14X14","","BATH","","9X8","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","RANCH/1S","AL/VINYL","NONE","NONE","","","COMP SHI","G-FWA","NONE","WTRSEWR","","","","DINROOM","","","PORCH,SM SHED","","","","","FIXER UP","","","CL LSTOF,ANYTIME","","","","6","","","MB5","2","1","","","PRINCETON","","","26","8,500","","PRIN 1ST EXIT TO BROADWAY TR RT GO TO RACE ST TR LEFT GO TO","","","","NO GIBSON","08/15/2002","","","","","","","1","","","","NO GIBSON","","","","STEEPLES SUB DIV 6","","[phone]","02/15/2002","769400","MWRE","NONE","50 X 100","","","","","","","NO GIBSON","","","","","","","","5","1.0000","","","","","","","","V","","","","","","","0190217300","","","","","","IMMED.","","R","","","","1104","P","IN","A","","N","RACE","626","","","N","2002","263","","","1.0000","","1104","PATOKA","","","","","","","","","","","","","","","","","1900","47670-","","SELL AS IS / 1ST TIME BUYER / GOOD RENTAL PROP","","","","","","","85925","8,500","","","","",""
"SFM","UNKNOWN","501","MIKE SITZMAN","COLDWELL BANKER KATTMANN REALT","[phone]","","","","","W OF 41 TO POSEY COUNTY LINE","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","NONE","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","RANCH/1S","WOOD","NONE","PARTIAL","FRAME","BLOCK","HIP","G-FWA","CNTL AIR","WTRSEWR","","","","FAM RM","","","","CHAINLNK","","","","","","CONVENT,CASH","LOCKBOX,ANYTIME","","","","1","","","MJ","2","1","","","EVANSVILLE","","","","8,900","","WASHINGTON AVE TO NORTH ON GARVIN WEST ON CHANDLER","","","","STRINGTOWN","04/01/2002","","","","","","","1","","","","CENTRAL","","","","SOUTHERN ENL LT 6 BL27","","[phone]","10/10/2000","681671","KATT","E-BOX","30X123","3690","","","","","","THOMPKINS","","","","","","","","4","1.0000","","","","","","","","V","","","","","","","11-080-21-060-028","","","","","","IMMED","","R","","","","1010","P","IN","A","","E","CHANDLER","512","","","N","2000","293","","3000","1.0000","","1010","PIGEON","","","","","","","","","","","","","","N","","","1900","47713-","","ATTENTION INVESTORS!","","","","","","","77409","8,900","TO BE SOLD IN (AS IS) CONDITION!","LOW TAXES!","","","10/11/2001"
"LND","UNKNOWN","43","JOANNE ROBB","AMERICAN REAL ESTATE, INC","[phone]","","","","","GIBSON COUNTY","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","1","","","N","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","CORNER","","CITY STR","","","","","GAS AVL,ELECTRIC,OTHER","CITY WTR","","","","","","CONVENT,CASH,CONTRACT","CALL LO","RES LAND","","","","","","","","","",".1900","6","","","C","","2","","","PRINCETON","","","26","9,475","","TAKE S.MAIN ST.SOUTH TO OHIO ST. TURN E.TO S.JEFFERSON ST.","","N","","PRINCETON","06/11/2002","","","","","","","","","","","PRINCETON","","","","17-2-10","","[phone]","01/11/2002","308283","AREI","","65X129","","","","","","","PRINCETON","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","L","","NG","","","","IN","A","","E","KENTUCKY","LOT 8","","SOUTH PARK","","","","","",".0000","","","PATOKA","","","","","","","","","","","","","","","","","","47670-","","NICE LOT IN SOUTH PARK ADD, PERFECT FOR MODULAR OR STICK BUILT HOME.","","","","","","","85270","9,475","","","","",""
"LND","UNKNOWN","43","JOANNE ROBB","AMERICAN REAL ESTATE, INC","[phone]","","","","","GIBSON COUNTY","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","1","","","S","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","CITY STR","","","","","GAS AVL,ELECTRIC","CITY WTR","","","","","C PARK","CONVENT,CASH,CONTRACT","","","","","","","","","","","",".1900","6","","","C","","2","","","PRINCETON","","","26","9,475","","TAKE S,MAIN ST. SOUTH TO OHIO ST. TURN L.TO LOTS ON LEFT.","","N","","PRINCETON","06/01/2002","","","","","","","","","","","PRINCETON","","","","17-2-10","","[phone]","01/11/2002","308283","AREI","","65X126","","","","","","","PRINCETON","","","","","","","","","","","","","","","","","V","","","","","","","","","","","","","","","L","","NG","","","","IN","A","","E","OHIO","LOT 9","","SOUTH PARK","","","","","",".0000","","","PATOKA","","","","","","","","","","","","","","","","","","47670-","","","","","","","","","85274","9,475","","","","",""
"LND","UNKNOWN","43","JOANNE ROBB","AMERICAN REAL ESTATE, INC","[phone]","","","","","GIBSON COUNTY","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","1","","","S","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","CITY STR","","","","","GAS AVL,ELECTRIC","CITY WTR","","","","","C PARK","CONVENT,CASH,CONTRACT","","","","","","","","","","","",".1900","6","","","C","","2","","","PRINCETON","","","26","9,475","","TAKE S,MAIN ST. SOUTH TO OHIO ST. TURN L.TO LOTS ON LEFT.","","N","","PRINCETON","06/01/2002","","","","","","","","","","","PRINCETON","","","","17-2-10","","[phone]","01/11/2002","308283","AREI","","80X127","","","","","","","PRINCETON","","","","","","","","","","","","","","","","","V","","","","","","","","","","","","","","","L","","NG","","","","IN","A","","E","OHIO","LOT 10","","SOUTH PARK","","","","","",".0000","","","PATOKA","","","","","","","","","","","","","","","","","","47670-","","","","","","","","","85275","9,475","","","","",""
"LND","UNKNOWN","43","JOANNE ROBB","AMERICAN REAL ESTATE, INC","[phone]","","","","","GIBSON COUNTY","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","1","","","S","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","CITY STR","","","","","GAS AVL,ELECTRIC","CITY WTR","","","","","C PARK","CONVENT,CASH,CONTRACT","","","","","","","","","","","",".1900","6","","","C","","2","","","PRINCETON","","","26","9,475","","TAKE S,MAIN ST. SOUTH TO OHIO ST. TURN L.TO LOTS ON LEFT.","","N","","PRINCETON","06/01/2002","","","","","","","","","","","PRINCETON","","","","17-2-10","","[phone]","01/11/2002","308283","AREI","","74X128","","","","","","","PRINCETON","","","","","","","","","","","","","","","","","V","","","","","","","","","","","","","","","L","","NG","","","","IN","A","","E","OHIO","LOT 14","","SOUTH PARK","","","","","",".0000","","","PATOKA","","","","","","","","","","","","","","","","","","47670-","","","","","","","","","85281","9,475","","","","",""

[Anon]

hmm...

Maybe you should try to create a new text file with only 1 or two rows with values in every row and see if your import is working properly.

It may be that your text file doesn't match your table schema, or your field enclosed by or line terminators are not correct.

take a look at http://www.mysql.com/doc/L/O/LOAD_DATA.html

[Anon]

caps will not make a difference

[irving]

I actually imported my text file into a MS Access database. Then exported it into a MySQL table. Then I cleared all of the data out. The only thing I have done is take spaces out of the column names and change the null or not null values.
I don't know. thanks.

[Anon]

I think this is a good one for Vincent.

[irving]

how do I get vincent to look at it?

[irving]

I have been playing with this and I have incremently removed rows of data until it was successful. The most amount of rows or records I have gotten is 1,362. Is there some kind of limit importing from a text file (data limit, time limit,etc.)? because I can export the entire amount of data from MS Access to this table.

[irving]

Dave,
there appears to be a 2MB limit of some kind on the size of the txt file. Have you ever heard of this?

[Anon]

I am not aware of a limit on filesize. I am not sure I have ever loaded anything that big either.