NumberRecords = GETWORDCOUNT(m.bnin) >> FOR i = 1 TO NumberRecords >> m.bn = PADL(GetWordNum(m.bnin, i, ","),7,"0") >> >> *Opens the DBF file in the "key" folder, appends "A" and adds the user input as batch number >> OpenTable(goWCServer.oConfig.oTask.cBTSPath+[key\A]+m.bn,[AppExp]) >> >> *Select columns from table above, name them for Excel headers >> SELECT bn as [BatchNum],; >> pk as [RecNo],; >> "" as [Approved],; >> shdt as [ShipDate],; >> canm as [Carrier],; >> prno as [Pro],; >> blno as [BOL],; >> shnm as [Shipper],; >> ozp as [OZip],; >> conm as [Consignee],; >> dzp as [DZip],; >> wtttl as [Weight],; >> "" as [ReWeigh],; >> "" as [Notes],; >> accd1 as [Acc1],; >> acamt1 as [Amt1],; >> accd2 as [Acc2],; >> acamt2 as [Amt2],; >> accd3 as [Acc3],; >> acamt3 as [Amt3]; >> FROM AppExp; >> ENDFOR >> >>*Copy data from cursor to Excel file >>COPY TO ("C:\test\"+[bn]+m.bn+[T2.xls])>