Copy data from excel and paste it onto Access datasheet form

  • Thread starter Thread starter Pmxgs
  • Start date Start date
P

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
 
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
Click to expand...

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]
 
Back
Top