extract info from form

[WesT]

I would like to paste aprox. 10 lines of info into a box on an input form and
have the form extract the different data on each line to the parts of a
record. I have hundreds of these that i would like to copy and paste into a
database without entering each one a line at a time. thanks in advance

example of paste:

date 04/27/07
time 13:45
level 5
item1 56
item2 21
item3 98
item4 103

put all this into a record

 

[Graham R Seach]

Wes,

There are easy ways of doing this, but you'll have to be a bit more specific
before we can really help you.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[WesT]

I would like to paste the 10 lines of info into one box on a form and have
the form take the different pieces of information and insert them into the
different fields of a record.

the table would have fields like: date time level item1 item2 item3 etc..

i hope this makes more sense

 

[Jan Kowalski]

Wes,

There are easy ways of doing this, but you'll have to be a bit more
specific before we can really help you.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Jan Kowalski]

I would like to paste aprox. 10 lines of info into a box on an input form
and
have the form extract the different data on each line to the parts of a
record. I have hundreds of these that i would like to copy and paste into
a
database without entering each one a line at a time. thanks in advance

example of paste:

date 04/27/07
time 13:45
level 5
item1 56
item2 21
item3 98
item4 103

put all this into a record

 

[Graham R Seach]

Wes,

I understood what you wanted to do. I just didn't understand exactly how the
data were structured.

You say you have data like date, time, level, item1, item2, item3, etc..
That's all very nice, but there are a few issues here.

Firstly, Access has no way to know what's what. Which bit is a date? Which
bit is a level? Can you *guarantee* the order in which they'll be pasted
(before you answer that, the answer is no).

Maybe there's a better way. We need to know exactly what you're trying to
do, so we can determine the best way to proceed.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia