Datasheet form: paste

  • 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,
 
do you mean manually highlighting a range of cells in an open Excel file,
copying them, then manually pasting them into an Access table via an open
form set to Datasheet view?

i didn't have any trouble doing the above using a small test Excel file and
Access table/form. i tried it using Ctrl+v to paste, and also using the
Paste button on the toolbar in Access.

you do have to highlight the "new" row at the bottom of the datasheet (the
whole row, or at least the number of fields that correspond with the number
of columns you're pasting). if you want to overwrite existing records, you
need to highlight at least the same number of rows you copied in Excel
(again, the whole row or at least the same number of fields as the number of
columns you're pasting).

i also made sure that the Excel data i copied was compatible with the Data
Type of the corresponding fields in the Access table (no Excel text data
into an Access number field, for instance).

hth

if you're wanting to do this programmatically, rather than manually, then of
course all the above is no help to you, sorry.
 
Back
Top