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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

turneg02 - 27 Jul 2005 03:22 GMT

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

Reply to this Message

Rick B - 27 Jul 2005 14:02 GMT

What are you trying to accomplish?

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

Signature

Rick B

> eg
>
[quoted text clipped - 11 lines]
>
> thanks

Reply to this Message

John Vinson - 27 Jul 2005 16:50 GMT

>eg
>
[quoted text clipped - 11 lines]
>
>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]

Reply to this Message