There are quite a few ways to do this

The crudest way could be

lcTxt=strtran(_cliptext,chr(9),',') && covert the xl tab chars to commas
strtofile(lcTxt,'myfile.txt')
sele mytable
append from myfile.txt delim

or

to get more control you could use the ALINES function to pu all the lines into an array and then just parse the array a line at a time. Or even just use the MLINE() function and do it a line at a time.

eg

lcTxt=_cliptext
for li = 1 to memlines(lcTxt)
lcLine=mline(lcTxt,li)
repl myfield1 with subs(lcline,5,6),myfield1 with subs(lcline,5,6) etc
next

I have not checked the above but it should give you some ideas

good luck







>I need to grab multi-line, multi-field text from the clipboard but don't know how to parse it with code.
>
>Basically, I'm thinking of having the user copy 2 columns of data from an Excel spreadsheet into clipboard and paste it into the database. I could use automation but the spreadsheet will have multiple worksheets so it makes things little more complicated.
>
>How can I paste what is in the clipboard in code? Something like:
>
>For Each "line" In "clipboardtext"
> Zipcode = Left(clipboardtext,5)
> Count = Val(Mid(clipboardtext,6))
>Next