>I had originally posted this question in another thread that dealt with the same topic in the reverse direction, so thought I'd reattempt as a new thread. :)
>
>I would like to paste a column of values from Excel into a VFP grid column. Does anyone know if this is easily accomplished? It does not appear that _CLIPTEXT knows how to handle this so I can't parse the copied Excel cells.
>
>Laterness,
>Jon
Jon,
_cliptext has data in TAB delimited format. Save it to a temp file, append to a cursor and process as you want. ie:
lcTemp = sys(2015)+'.tmp'
StrToFile(_cliptext,lcTemp)
select myFieldA from gridRecSource where .f. into cursor crsTemp readwrite
append from (lcTemp) type delimited with tab
erase (lcTemp)
Cetin