>I don't see a where on your query. Without the where you will always get the first row.
>

Don't you mean you will always get all rows?


>>>>Alright, I just tried it and it's still only giving me the first file I type in, ignoring the comma and other file I type after it... This is what the code looks like now:
>>>>
>>>>

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

>>>
>>>you've got the endfor in the wrong place, it should be after the copy to
>>
>>
>>I just tried that too and get the same result... I don't get it.