Data entry field where I can paste a list?

[mikewood1980]

Hello Everyone

I don't know whether this is possible but, I am creating a data entry form and it would be helpful to be able to paste contents of a column in excel into a field in my form (to save typing the data in cell by cell). Is this possible? If so, can you suggest how I might go about this?

Many thanks for your help!
MikeW

 

[DCrake]

Simple Software Solutions

From what you are describing you want to copy the contents of many cells in Excel into one field for one record into Access. Is this what you actually want to do? If not rephrase your question more clearly.

 

[mikewood1980]

Thanks...

The list will be copied from excel like this
1
2
3
4
5
6
etc...

Then (if possible) pasted into the form like this
1
2
3
4
5
6
etc...

Each number 1, 2, 3, 4, etc will then be written to SEPARATE records.

Hope this clear this up! Thanks for getting back so quick!
MikeW

 

[Dee Cee]

I think this is what you are tring to do:

You could import the excel data you need into a table in access. Then using a combobox on your data entry form look up the data in the newly created table as a control for that field.

 

[mikewood1980]

Thanks Dee Cee

Yeah - it works fine when pasting from excel, but I would rather paste straight from the NorSonic program that we are using straight into the form is this is possible (otherwise we would have to open excel too during the data entry process)

Thanks again
Mike Wood

 

[neileg]

You said you were using Excel!

You need to know what the copied data looks like. Are the records separated by returns, commas or what. Do a copy and paste into Notepad to see.

 

[DCrake]

Simple Software Solutions

What is NorSonic? How does it store its own data.

Your original post required the knowldege of how to copy the contents of an Excel worksheet range into Access. This can be done blindly, however, it looks like you have changed the goalposts.

You state copy straight onto your form, yes, ok, but how are you intending to display it? listbox, combo box, subform?

Not enough info to give you a definiative answer.

 

[mikewood1980]

Sorry Guys - i replied straight from my email and thought I was replying to a later thread!! I've pasted the data into a text file and it looks like this:

any ideas??
Thanks again Mike

 

[DCrake]

Simple Software Solutions

I have seen threads regarding this post elsewhere has this issue been resolved?

 

[mikewood1980]

I have seen threads regarding this post elsewhere has this issue been resolved?

Hi DCrake

I've literally just posted a reply to the other thread! I've sorted it out - I pasted the results into one large text box and used the split() function with vbLf as the delimiter argument and put the results into an array.

Thanks for your time + help!

Mike

 

[neileg]

Looks like this issue is closed.