List in Data Access Page: string to individual data pieces

A

amy suzanne lynch

I'm designing a Data Access Page that would ideally allow the user to input a
list of words into a textbox {ex: "printer, copier, computer, file cabinet"}
and then have those words show up in a table, all as separate records:

printer
copier
computer
file cabinet


how would i achieve that?
 
Top