Input data form

[Boon]

Hello,

I am creating a form that will receive the data from a user. The situation
is the following... A user receive a data in excel file. In excel file, the
data contains only one row and 5 columns. The easiest way (and the way I
want it to be) is to tell a user to copy those 5 cells in excel (Ctrl+C),
and go to Access form, then paste the data. My question is how should I make
the form so that a user can paste (Ctrl+V) in the the boxes. After a user
paste into the 'receiving' boxes, I will create a button that will append a
new data into a table.

Thank you,
Boon

 

[Tom van Stiphout]

On Fri, 5 Dec 2008 14:48:13 -0600, "Boon"

I would probably have her paste the data in a textbox, and then use
the Split function on vbTab to pick apart the individual values.

-Tom.
Microsoft Access MVP