I have to imagine this could be done more easily by either saving the worksheet in Excel as a DBF (you can limit it to the two columns containing SSN and earnings) or importing (or appending from) the worksheet into a table in VFP.

>I have a large, very wide spreadsheet in ecxel that has employee social security number in one column and one blank column for earnings figures. The spreadsheet cannot easily be exported to a table because of its complexity.
>
>
>I have a VFP table with the ss# and the earnings figures. Is there some way to have vfp access the spreadsheet, locate the ss# and write the earnings in the adjacent column? I cant fathom having to do this by hand.
>
>
>TIA
>Chris