How to easily copy existing information into a record as a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

eg

sugar,* beans ,* water

and i want it to stored as

sugar
beans
water

in the access database
i could copy make them into a list like that and then paste it in correct
cell but theres thousands of records so im looking for a quick and easy way

thanks
 
What are you trying to accomplish?

Your post is not clear. Also, you are using terms like "cells" which refer
to Excel, not Access.
 
eg

sugar,* beans ,* water

and i want it to stored as

sugar
beans
water

in the access database
i could copy make them into a list like that and then paste it in correct
cell but theres thousands of records so im looking for a quick and easy way

thanks
Click to expand...

You'll need some VBA code to parse the text string into components,
using the Split function. I'm not sure I understand the format: what
are the asterisks? Are they just delimiters that you want to get rid
of? What about the (inconsistent) leading and trailing blanks?

John W. Vinson[MVP]
 
Back
Top