Load external data into an unbound text box...then append to a table. Options

L

leewilman40

I have a form with a text box I load (copy and paste) data like
examples below, no limit. I then press a button that will append the
data into a table. It will only select distinct records and in
Ascending order. Could you provide me with some simple code to do
this, much appreciated? It will also accept text and number values.

Blue
Red
Orange
Blue
White
Yellow


Thanks
 
Top