> >
> > I should also add this excel(csv) file uses data all the way to columns BC
> > and contains 20k+ rows of data. This one code is all I need to change.
> > Mike
>
> Mike,
> Sorry I couldn't understand your requirement exactly. Maybe you want to change it directly in Excel w/o getting into VFP? If so:
>
>

lcXLS = getfile('XLS')
> oExcel = createobject('Excel.Application')
> with oExcel
>  .Workbooks.Open(m.lcXLS)
>  .Visible = .t.
>  with .ActiveWorkbook.Activesheet
>     for ix = 1 to .UsedRange.Rows.Count
>       if .Cells(m.ix,1).Value = '0125' and .Cells(m.ix,2).Value ='FDC'
>          .Cells(m.ix,2).Value = 'IDC'
>       endif
>     endfor
>  endwith
> endwith

>
> This would be slow but for 20K might not be important. You can also directly open Excel sheet as a cursor (CursorAdapter and ACE OleDb driver - check message id 153776 for a sample) and do an update.
>
>
> Or do you mean you want to put the changed data back to Excel? - 153776 has a sample for that too.
>
> PS: I think I need to repeat that it is not a CSV file. Append from .. type CSV would fail.
>
> Cetin Basoz


This code looks like it will do the job. Since I already have the file open I plan to just run the code to change the FDC to IDC and then continue on with the orig. processing of the file into tables.
Thank you and will give it a shot on Monday.
Like I said you are on top of it!!