Hello, I am having trouble with some code and I was hoping someone could help me out. I am writing an excel macro that uses ADO to connect to a comma delimited text file and retrive data. The following are the problems I am having:
1. I have no headers in my text file, but it is being treated as if it had a header row when I fill my record set ( it automatically starts on row 2) how do I get it to look at row1 first
2. I am using "MoveNext" to move through the recordset one record at a time. when I create a small test textfile this code works fine, but an interesting problem is occurring on a larger text file i am testing: MoveNext is skipping every other row. Why would it do this
The following is my code:
Function Import(Symbol As String)
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strSQL As String
cn.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\;Extensions=asc,csv,tab,txt;"
strSQL = "SELECT * FROM Pwr3Lnk671gnA55.txt"
rs.Open strSQL, cn
Do Until rs.EOF
If rs.Fields(11) = Symbol Then
Import = rs.Fields(2)
Exit Do
End If
rs.MoveNext
Loop
If Import = "" Then
Import = "NA"
End If
End Function
Sub test()
Debug.Print Import("AETUF")
End Sub
the following is the large text file that is not working:
"55555555","AIM ADVANTAGE HEALTH SCIENCES FUND CLASS A M/F",+39608.0000,00/00/00,18.6000000,.0000,.00000,"00"," ","Y","25","IAGHX","13.949",".00000","00/00/00","00141A404000000 ","
"55555555","ARC ENERGY TR UNIT TR (CANADA)",+24000.0000,00/00/00,23.3270000,2.0560,.00000,"04"," ","Y","14","AETUF","7.600",".00000","00/00/00","001986108000000 ","
"55555555","AIM GLOBAL GROWTH FUND CLASS A M/F",+2505.3230,00/00/00,21.6700000,.1310,.00000,"00"," ","Y","25","AGGAX",".000",".00000","00/00/00","008882300000000 ","
"55555555","AIM EUROPEAN GROWTH FUND CLASS A M/F",+3327.5460,00/00/00,35.6800000,.2140,.00000,"00"," ","Y","25","AEDAX",".000",".00000","00/00/00","008882854000000 ","
"55555555","ALERIS INTERNATIONAL INCORPORATED",+5000.0000,00/00/00,46.8100000,.0000,.00000,"00"," ","Y","01","ARS",".000",".00000","00/00/00","014477103000000 ","
"55555555","ALLIANCE BERNSTEIN INTL GROWTH FUND CLASS A M/F",+5353.1070,00/00/00,17.4800000,.0910,.00000,"12"," ","Y","25","AWPAX",".000",".00000","00/00/00","01879X103000000 ","
"55555555","ALLIANZ OCC RENAISSANCE FUND CLASS D N/L",+5102.9300,00/00/00,22.8200000,.0000,.00000,"00"," ","Y","25","PREDX",".000",".00000","00/00/00","018918672000000 ","
"55555555","AMERICAN LD LEASE INCORPORATED REIT",+16000.0000,00/00/00,27.6900000,1.0000,.00000,"02","Q","Y","14","ANL","14.500",".00000","00/00/00","027118108000000 ","
"55555555","ANADARKO PETE CORPORATION ",+5000.0000,00/00/00,100.5500000,.7200,.00000,"03","Q","Y","01","APC",".000",".00000","00/00/00","032511107000000 ","
"55555555","APACHE CORPORATION ",+13000.0000,04/23/04,65.6200000,.4000,.00000,"05","Q","Y","01","APA",".000",".00000","00/00/00","037411105000000 ","
"55555555","AUTONATION INCORPORATED ",+7500.0000,00/00/00,21.5300000,.0000,.00000,"06"," ","Y","01","AN",".000",".00000","00/00/00","05329W102000000 ","
"55555555","AUTOZONE INCORPORATED ",+2000.0000,07/07/04,98.2600000,.0000,.00000,"00"," ","Y","01","AZO","78.922",".00000","00/00/00","053332102000000 ","
"55555555","BAXTER INTERNATIONAL INCORPORATED",+10000.0000,03/14/03,38.7600000,.5820,.00000,"01","A","Y","01","BAX","21.014",".00000","00/00/00","071813109000000 ","
"55555555","BEAR STEARNS COMPANIES INCORPORATED",+1000.0000,07/17/02,138.1400000,1.1200,.00000,"04","Q","Y","01","BSC","57.784",".00000","00/00/00","073902108000000 ","
"55555555","BLACKROCK INVT QUALITY MUN TR ",+9383.0000,00/00/00,17.9100000,1.0590,.00000,"04","M","N","2A","BKN","12.730",".00000","00/00/00","09247D105000000 ","
"55555555","BLACKROCK INSD MUN 2008 TRM TR ",+4150.0000,00/00/00,15.7200000,.7950,.00000,"04","M","N","2A","BRM","14.884",".00000","00/00/00","09247K109000000 ","
"55555555","BRADLEY PHARMACEUTICALS INCORPORATED",+10000.0000,00/00/00,14.2800000,.0000,.00000,"00"," ","Y","01","BDY",".000",".00000","00/00/00","104576103000000 ","
"55555555","BRANDYWINE RLTY TR SH BEN INT NEW",+10000.0000,00/00/00,30.9200000,1.6800,.00000,"04","Q","Y","14","BDN",".000",".00000","00/00/00","105368203000000 ","
"55555555","BRIGGS & STRATTON CORPORATION ",+5000.0000,00/00/00,35.0300000,.8800,.00000,"04","Q","Y","01","BGG",".000",".00000","00/00/00","109043109000000 ","
"55555555","BRISTOL MYERS SQUIBB COMPANY ",+8000.0000,00/00/00,25.5200000,1.1200,.00000,"05","Q","Y","01","BMY","26.416",".00000","00/00/00","110122108000000 ","
"55555555","CALAMOS GROWTH FUND CLASS A M/F",+8688.0970,00/00/00,57.5800000,.0000,.00000,"00"," ","Y","25","CVGRX",".000",".00000","00/00/00","128119302000000 ","
"55555555","CARDIAC SCIENCE CORPORATION ",+1038.0000,00/00/00,9.1000000,.0000,.00000,"00"," ","Y","01","CSCX",".000",".00000","00/00/00","14141A108000000 ","
"55555555","CENTRAL EUROPE AND RUSSIA FD ",+15313.0000,00/00/00,48.4000000,.3300,.00000,"12","A","Y","14","CEE",".000",".00000","00/00/00","153436100000000 ","
"55555555","CHESAPEAKE ENERGY CORPORATION ",+20000.0000,04/23/04,31.2000000,.2000,.00000,"04","Q","Y","01","CHK",".000",".00000","00/00/00","165167107000000 ","
"55555555","CITIGROUP INCORPORATED ",+5000.0000,09/25/02,47.8100000,1.9600,.00000,"02","Q","Y","01","C","27.515",".00000","00/00/00","172967101000000 ","
"55555555","COLONIAL HIGH INCOME MUN TR SH BEN INT",+10000.0000,00/00/00,7.0300000,.4440,.00000,"04","M","N","2A","CXE","7.916",".00000","00/00/00","195743109000000 ","
"55555555","COMCAST CORPORATION NEW CLASS A",+4000.0000,05/23/02,26.5600000,.0000,.00000,"00"," ","Y","01","CMCSA","31.405",".00000","00/00/00","20030N101000000 ","
"55555555","COMSTOCK RES INCORPORATED COM NEW",+61100.0000,00/00/00,29.3700000,.0000,.00000,"00"," ","Y","01","CRK",".000",".00000","00/00/00","205768203000000 ","
"55555555","CONTRARIAN OPPORTUNITIES FUND LIMITED PARTNERSHIP",+304.3935,00/00/00,2987.5213000,.0000,.00000,"00"," ","Y","39","1CTOP","656.656",".00000","00/00/00","212900914000000 ","
"55555555","CORA HEALTH SERVICES INC SERIES C CONV PFD",+419166.0000,12/04/03,.0000000,.0000,.00000,"00"," ","Y","05","21775RRJ",".000",".00000","00/00/00","21775RRJ0000000 ","
"55555555","CORA HEALTH SERVICES INC SER B CONV PREFERRED $.001 SHARE PAR",+419166.0000,00/00/00,.0000000,.0000,.00000,"00"," ","Y","05","CRA.PRRF",".883",".00000","00/00/00","21775XRJ7000000 ","
"55555555","CORA HEALTH SERVICES INC SER A CONV PFD",+1000000.0000,06/02/98,.0000000,.0000,.00000,"00"," ","Y","05","1CORA","1.000",".00000","00/00/00","217900935000000 ","
"55555555","CORA HEALTH SERVICES INCORPORATED",+29000.0000,00/00/00,.0000000,.0000,.00000,"00"," ","Y","01","1CCRA",".000",".00000","00/00/00","217900943000000 ","
"55555555","EAGLE GROWTH PARTNERS I LIMITED PARTNERSHIP",+37.1300,00/00/00,29100.0000000,.0000,.00000,"00"," ","Y","39","1EGEL","26364.355",".00000","00/00/00","269900999000000 ","
"55555555","EAGLE AGGRESSIVE GROWTH PARTNERS LIMITED PARTNERSHIP",+18.2100,03/20/02,43500.0000000,.0000,.00000,"00"," ","Y","39","1EAGB",".000",".00000","00/00/00","269901914000000 ","
"55555555","EDWARDS AG INCORPORATED ",+1000.0000,00/00/00,45.7900000,.8000,.00000,"04","Q","Y","01","AGE","35.765",".00000","00/00/00","281760108000000 ","
"55555555","EMBREX INCORPORATED ",+10000.0000,00/00/00,11.1500000,.0000,.00000,"00"," ","Y","01","EMBX","11.784",".00000","00/00/00","290817105000000 ","
"55555555","FIDELITY ADVISOR DIVERSIFIED INTERNATIONAL FUND CLASS I N/L",+44903.4580,00/00/00,23.1400000,.1780,.00000,"00"," ","Y","25","FDVIX",".000",".00000","00/00/00","315920686000000 ","
"55555555","FIDELITY NATL INFORMATION SVCS ",+2500.0000,00/00/00,40.0600000,.2000,.00000,"03","Q","Y","01","FIS",".000",".00000","00/00/00","31620M106000000 ","
"55555555","FIRST AMERICAN INTERNATIONAL FUND CLASS A M/F",+18816.8590,00/00/00,13.8300000,.1310,.00000,"00"," ","Y","25","FAIAX",".000",".00000","00/00/00","318530615000000 ","
"55555555","FIRST EAGLE GLOBAL FUND CLASS A M/F",+7584.1280,00/00/00,44.8400000,.8450,.00000,"00"," ","Y","25","SGENX",".000",".00000","00/00/00","32008F507000000 ","
"55555555","FIRST INDUSTRIAL REALTY TRUST REIT",+20000.0000,00/00/00,42.9000000,2.8000,.00000,"04","Q","Y","14","FR",".000",".00000","00/00/00","32054K103000000 ","
"55555555","GRT INCORPORATED ",+131872.0000,00/00/00,.0000000,.0000,.00000,"00"," ","Y","01","1GRTI",".497",".00000","00/00/00","362901936000000 ","
"55555555","HEALTH CARE REIT INCORPORATED REIT",+18000.0000,00/00/00,37.3900000,2.4800,.00000,"02","Q","Y","14","HCN","19.359",".00000","00/00/00","42217K106000000 ","
"55555555","HERITAGE CAPITAL APPRECIATION TRUST FUND CLASS A M/F",+7921.1840,00/00/00,29.1100000,.0000,.00000,"12"," ","Y","25","HRCPX","13.892",".00000","00/00/00","426906103000000 ","
"55555555","HERITAGE GROWTH AND INCOME TRUST FUND CLASS A M/F",+34102.4890,00/00/00,13.9100000,.2680,.00000,"04"," ","Y","25","HRCVX",".000",".00000","00/00/00","42724C100000000 ","
"55555555","HERITAGE SMALL CAP STOCK FUND CLASS A M/F",+11500.4410,00/00/00,37.0500000,.0000,.00000,"00"," ","Y","25","HRSCX",".000",".00000","00/00/00","42725G100000000 ","
"55555555","HERITAGE DIVERSIFIED GROWTH FUND CLASS A M/F",+48534.3230,00/00/00,28.7700000,.0000,.00000,"00"," ","Y","25","HAGAX",".000",".00000","00/00/00","42725G787000000 ","
"55555555","HERITAGE MID CAP STOCK FUND CLASS A M/F",+15298.1500,00/00/00,28.9200000,.0000,.00000,"00"," ","Y","25","HMCAX",".000",".00000","00/00/00","42725G860000000 ","
"55555555","HERITAGE INTERNATIONAL EQUITY FUND CLASS A M/F",+13934.7360,00/00/00,27.7400000,.1640,.00000,"00"," ","Y","25","HEIAX",".000",".00000","00/00/00","42725G886000000 ","
"55555555","ITC DELTACOM INCORPORATED WARRANT EXP 102107",+95.0000,12/31/02,.0000000,.0000,.00000,"00"," ","Y","08","ITCDW",".000",".00000","00/00/00","45031T120000000 ","
"55555555","ITC DELTACOM INCORPORATED PREFERRED CONV",+36.0088,00/00/00,.0000000,.0000,.00000,"07"," ","Y","05","45031T50",".000",".00000","00/00/00","45031T500000000 ","
"55555555","INDIA FD INCORPORATED ",+10269.0000,00/00/00,48.2500000,4.4600,.00000,"01","A","Y","14","IFN",".000",".00000","00/00/00","454089103000000 ","
"55555555","INSIGHT ENTERPRISES INCORPORATED",+10000.0000,00/00/00,21.6100000,.0000,.00000,"09"," ","Y","01","NSIT",".000",".00000","00/00/00","45765U103000000 ","
"55555555","INTEL CORPORATION ",+1000.0000,00/00/00,19.6000000,.4000,.00000,"06","Q","Y","01","INTC","14.551",".00000","00/00/00","458140100000000 ","
"55555555","JP MORGAN CHASE & COMPANY ",+7500.0000,09/25/02,42.1000000,1.3600,.00000,"04","Q","Y","01","JPM",".000",".00000","00/00/00","46625H100000000 ","
"55555555","JEFFERIES GROUP INCORPORATED NEW",+2000.0000,07/17/02,57.5200000,.6000,.00000,"03","Q","Y","01","JEF","19.417",".00000","00/00/00","472319102000000 ","
"55555555","JENNISON SMALL COMPANY FUND INC CLASS A M/F",+25354.9700,00/00/00,20.4400000,.0000,.00000,"00"," ","Y","25","PGOAX",".000",".00000","00/00/00","47629P106000000 ","
"55555555","KNOLOGY INCORPORATED ",+18708.0000,12/31/03,5.9000000,.0000,.00000,"00"," ","Y","01","KNOL",".000",".00000","00/00/00","499183804000000 ","
"55555555","KNOLOGY INCORPORATED PREFERRED CNV SERIES AA ISIN",+24290.0000,00/00/00,25.3000000,.0000,.00000,"00"," ","Y","05","KNOL.PRP",".000",".00000","00/00/00","499183879000000 ","
"55555555","MFS INTERNATIONAL NEW DISCOVERY FUND CLASS A M/F",+20024.0290,00/00/00,25.9500000,.0000,.00000,"00"," ","Y","25","MIDAX",".000",".00000","00/00/00","552981888000000 ","
"55555555","MANOR CARE INCORPORATED NEW ",+5000.0000,02/19/02,43.9500000,.6400,.00000,"02","Q","Y","01","HCR","19.115",".00000","00/00/00","564055101000000 ","
"55555555","MEDCO HEALTH SOLUTIONS INCORPORATED",+301.0000,05/23/02,60.1800000,.0000,.00000,"08"," ","Y","01","MHS","25.303",".00000","00/00/00","58405U102000000 ","
"55555555","MERRILL LYNCH & COMPANY INCORPORATED",+5000.0000,07/17/02,77.5500000,1.0000,.00000,"02","Q","Y","01","MER","38.635",".00000","00/00/00","590188108000000 ","
"55555555","MEXICO FD INCORPORATED ",+6672.0000,00/00/00,30.4500000,.6650,.00000,"01"," ","Y","14","MXF",".000",".00000","00/00/00","592835102000000 ","
"55555555","MORGAN STANLEY COM NEW",+5000.0000,00/00/00,61.4700000,1.0800,.00000,"04","Q","Y","01","MS","41.115",".00000","00/00/00","617446448000000 ","
"55555555","MORGAN STANLEY ASIA PAC FD INCORPORATED",+7553.0000,00/00/00,16.2500000,.1840,.00000,"01","A","Y","14","APF","7.855",".00000","00/00/00","61744U106000000 ","
"55555555","MORGAN STANLEY MUN INCOME III ",+5000.0000,03/08/96,9.6900000,.5400,.00000,"03","M","N","2A","OIC","9.041",".00000","00/00/00","61745P437000000 ","
"55555555","MORGAN STANLEY INSD MUN SECS",+5000.0000,03/11/96,14.2800000,.6300,.00000,"03","M","N","2A","IMS","13.041",".00000","00/00/00","61745P833000000 ","
"55555555","NGP CAP RES COMPANY ",+50000.0000,00/00/00,13.3200000,.6400,.00000,"04","Q","Y","01","NGPC",".000",".00000","00/00/00","62912R107000000 ","
"55555555","NEWELL RUBBERMAID INCORPORATED ",+5000.0000,01/26/04,25.4400000,.8400,.00000,"03","Q","Y","01","NWL","23.115",".00000","00/00/00","651229106000000 ","
"55555555","NUVEEN INSD PREM INCOME MUN 2 ",+12876.0000,00/00/00,12.9100000,.6840,.00000,"04","M","N","2A","NPX","12.244",".00000","00/00/00","6706D8104000000 ","
"55555555","OUTBACK STEAKHOUSE INCORPORATED",+7447.0000,00/00/00,43.9700000,.5200,.00000,"03","Q","Y","01","OSI",".000",".00000","00/00/00","689899102000000 ","
"55555555","PFIZER INCORPORATED ",+14000.0000,00/00/00,26.0200000,.9600,.00000,"03","Q","Y","01","PFE",".000",".00000","00/00/00","717081103000000 ","
"55555555","PIONEER NAT RES COMPANY ",+5000.0000,00/00/00,43.0000000,.2400,.00000,"04","S","Y","01","PXD","33.520",".00000","00/00/00","723787107000000 ","
"55555555","PLAINS EXPL& PRODTN COMPANY ",+13000.0000,00/00/00,37.8500000,.0000,.00000,"00"," ","Y","01","PXP",".000",".00000","00/00/00","726505100000000 ","
"55555555","T. ROWE PRICE MEDIA & TELECOMMUNICATIONS FUND N/L",+3512.1230,00/00/00,35.9300000,.0000,.00000,"12"," ","Y","25","PRMTX","17.739",".00000","00/00/00","741454102000000 ","
"55555555","PROSPERITY BANCSHARES INCORPORATED",+2800.0000,11/05/03,29.7200000,.4000,.00000,"04","Q","Y","01","PRSP","8.940",".00000","00/00/00","743606105000000 ","
"55555555","PUTNAM TAX EXEMPT INCOME FUND CLASS A M/F",+14240.0610,00/00/00,8.7600000,.3770,.00000,"12"," ","Y","1A","PTAEX",".000",".00000","00/00/00","746870104000000 ","
"55555555","PUTNAM TAX FREE HEALTH CARE FD SH BEN INT",+13402.0000,00/00/00,12.1840000,.5720,.00000,"04","M","N","2A","PMH","14.581",".00000","00/00/00","746920107000000 ","
"55555555","RADIOSHACK CORPORATION ",+5000.0000,00/00/00,18.9400000,.2500,.00000,"12","A","Y","01","RSH",".000",".00000","00/00/00","750438103000000 ","
"55555555","RAYMOND JAMES FINANCIAL INCORPORATED",+214649.0000,00/00/00,29.0000000,.3200,.00000,"03"," ","Y","01","RJF",".000",".00000","00/00/00","754730109000000 ","
"55555555","SCHRODER U.S. OPPORTUNITIES FUND INVESTOR SHARES N/L",+46685.3410,00/00/00,22.1300000,.0000,.00000,"00"," ","Y","25","SCUIX",".000",".00000","00/00/00","808088405000000 ","
"55555555","SENIOR HSG PPTYS TR SH BEN INT REIT",+25000.0000,00/00/00,18.3100000,1.2800,.00000,"02","Q","Y","14","SNH","11.061",".00000","00/00/00","81721M109000000 ","
"55555555","SERVICE CORPORATION INTERNATIONAL",+10000.0000,02/19/02,8.0800000,.1000,.00000,"04","Q","Y","01","SCI","4.762",".00000","00/00/00","817565104000000 ","
"55555555","SONIC AUTOMOTIVE INCORPORATED CLASS A",+17500.0000,07/07/04,28.4300000,.4800,.00000,"04","Q","Y","01","SAH",".000",".00000","00/00/00","83545G102000000 ","
"55555555","STIFEL FINL CORPORATION ",+1333.0000,07/17/02,39.6700000,.0000,.00000,"09"," ","Y","01","SF","9.168",".00000","00/00/00","860630102000000 ","
"55555555","STONEMOR PARTNERS L P COM UNITS",+10000.0000,00/00/00,20.4100000,1.9000,.00000,"02","Q","Y","3A","STON",".000",".00000","00/00/00","86183Q100000000 ","
"55555555","SWISS HELVETIA FD INCORPORATED ",+8296.0000,00/00/00,16.8700000,.0210,.00000,"01"," ","Y","14","SWZ",".000",".00000","00/00/00","870875101000000 ","
"55555555","TAMARAC FLA, GENERAL OBLIGATIO REFUNDING BONDS OID FGIC INSUR",+100000.0000,01/10/92,103.3410000,.0000,.05709,"09","S","N","88","TAMR07","99.732",".05900","09/01/07","875049BQ0000000 ","
"55555555","TAMPA FL WATER AND SEWER REVEN AND SEWER SYSTEMS REVENUE BOND",+200000.0000,04/27/82,72.5390000,.0000,.00000,"10"," ","N","89","3TFW15","34.619",".00000","10/01/15","875290BQ0000000 ","
"55555555","TECH DATA CORPORATION ",+15000.0000,00/00/00,36.3300000,.0000,.00000,"00"," ","Y","01","TECD",".000",".00000","00/00/00","878237106000000 ","
"55555555","TELLABS INCORPORATED ",+5000.0000,00/00/00,15.3500000,.0000,.00000,"05"," ","Y","01","TLAB","5.920",".00000","00/00/00","879664100000000 ","
"55555555","TEMPLETON DRAGON FD INCORPORATED",+2000.0000,01/19/95,21.7500000,.5830,.00000,"04","S","Y","14","TDF","11.352",".00000","00/00/00","88018T101000000 ","
"55555555","TUTOGEN MEDICAL INCORPORATED ",+3147.0000,04/15/04,4.8900000,.0000,.00000,"00"," ","Y","01","TTG","1.305",".00000","00/00/00","901107102000000 ","
"55555555","WCI CMNTYS INCORPORATED ",+5000.0000,02/07/03,29.1400000,.0000,.00000,"00"," ","Y","01","WCI",".000",".00000","00/00/00","92923C104000000 ","
"55555555","WACHOVIA CORPORATION 2ND NEW ",+3000.0000,12/20/99,56.4100000,2.0400,.00000,"03","Q","Y","01","WB","32.818",".00000","00/00/00","929903102000000 ","
"55555555","WHITING PETE CORPORATION NEW ",+5000.0000,00/00/00,39.7800000,.0000,.00000,"00"," ","Y","01","WLL",".000",".00000","00/00/00","966387102000000 ","
"55555555","WINSTON HOTELS INCORPORATED REIT",+55000.0000,00/00/00,11.2000000,.6000,.00000,"04","Q","Y","14","WXH","8.683",".00000","00/00/00","97563A102000000 ","
"55555555","WYETH ",+5000.0000,07/17/02,49.8700000,1.0000,.00000,"03","Q","Y","01","WYE","32.015",".00000","00/00/00","983024100000000 ","
"55555555","XTO ENERGY INCORPORATED ",+6666.0000,04/23/04,43.0600000,.3000,.00000,"04","Q","Y","01","XTO",".000",".00000","00/00/00","98385X106000000 ","
"55555555","AMDOCS LIMITED ORD (UNITED KINGDOM)",+15000.0000,00/00/00,34.0400000,.0000,.00000,"00"," ","Y","13","DOX","8.710",".00000","00/00/00","G02602103000000 ","
"55555555","CASH BALANCE ",-260.2500,00/00/00,1.0000000,.0000,.00000,"00"," ","Y","15"," ",".000",".00000","00/00/00"," ","
"55555555","HERITAGE MUNI TRUST MONEY MARKET FUND",+14320375.5800,00/00/00,1.0000000,.0257,.00000,"00"," ","N","15"," ",".000",".00000","00/00/00"," ","
Thanks for any help you can provide.
Dudeman

Problems when accessing a text file using ADO
Jaxsurfer
In any case, using ColNameHeader=False in the Schema.ini file (not HRD=No, which is what I had) corrected the problem.
WXU
Here's some additional info from our support engineer:
Hi Dudeman,
Thank you for contacting Microsoft ISV Partner Support.
1.Your first question is how to get the data at row1 first from the txt file.
You can insert a blank row in the txt file or and the column name as the first row. Then you will not miss a row data.
2. Your second question is “MoveNext is skipping every other row”.
It’s because your txt file format.
In each line you should end with a comma, but in your first line, it end with (,”) with a redundant quotation mark. Please remove it in each end-of-line.
The sample code is here:< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
======================================
Sub test2()
Dim oConn As New ADODB.Connection
Dim oRs As New ADODB.Recordset
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\;" & _
"Extended Properties=""text;HDR=Yes;FMT=CSVDelimited"""
oRs.Open "Select * From [1.txt]", oConn, adOpenStatic, adLockReadOnly, adCmdText
While oRs.EOF = False
Debug.Print oRs.Fields(11) & " / "
Debug.Print oRs.Fields(12)
oRs.MoveNext
Wend
End Sub
===
The text file is
"55555555","ARC ENERGY TR UNIT TR (CANADA)",+24000.0000,00/00/00,23.3270000,2.0560,.00000,"04"," ","Y","14","AETUF","7.600",".00000","00/00/00","001986108000000 ",
"55555555","SCIENCES FUND CLASS A M/F",+39608.0000,00/00/00,18.6000000,.0000,.00000,"00"," ","Y","25","AET3UF","13.949",".00000","00/00/00","< xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" />00141A 404000000 ",
-brenda (ISV Buddy Team)
kubilay
Please see: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2571726&SiteID=1
Alex Cane
nalsur8
dudeman,
why don't you read the file line by line like a text file and split each line into an array using the split() function
If ADO is causing problems then don't use it.