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

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top