Copy data from excel and paste it onto Access datasheet form

[Pmxgs]

Hi everyone,

i set up a form as a datasheet.
But since the amount of information i want to fill in that form is big, it
would be useful if i could copy range off cells from excel and paste it
directly onto the form.
The problem is that the form doesn't accept the figures.
Can someone help me how to make this possible?

thanks in advance,

Pedro

 

[John Vinson]

Hi everyone,

i set up a form as a datasheet.
But since the amount of information i want to fill in that form is big, it
would be useful if i could copy range off cells from excel and paste it
directly onto the form.
The problem is that the form doesn't accept the figures.
Can someone help me how to make this possible?

thanks in advance,

Pedro

I'd suggest using File... Get External Data... Import to import the
data directly into the Table. The imported data can then be displayed
or edited on your Form.

John W. Vinson[MVP]