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])>>