Copy/Paste rows from excell into access form..?

[MrDeej]

Is there any way to do this?

I want to copy these:



and paste them here


-

I have tried ctrl+c and ctrl+v but what happends then is that access puts the 2 numbers like this
914161
914210
in the textbox and access gives me an error-code of invalid number something.
I want it to first put 914161 and then access should make a new post for 914210



Any tips on this case?

- MD

[Stewart Ross]

Hi. If the ID number is the first field in the underlying query on which your form is based you should be able to use Paste Append instead of Paste. However, if you are pasting a single field value be careful of any constraints on the other fields not being null, or requiring related records in other tables, as the new appended records cannot be stored if such constraints are broken.

-Stewart

[MrDeej]

Hi. If the ID number is the first field in the underlying query on which your form is based you should be able to use Paste Append instead of Paste. However, if you are pasting a single field value be careful of any constraints on the other fields not being null, or requiring related records in other tables, as the new appended records cannot be stored if such constraints are broken.

-Stewart

Thank you Stewart!

But what is "Paste append" ?
My norwegian does not cover this frase. I kan only find paste vent i rightclick in excel after copying 2 rows from Excel

[blad3runn69]

pasting into a serious database table requires formatting in thai massage... ;)
Stewart alluded to it with Paste Append instead of Paste...

[Stewart Ross]

Hi. As BladeRunner mentions, Paste Append is an Access menu command available from the Edit menu. I will attach a screenshot for you. I don't think there is a keyboard shortcut for Paste Append.

-Stewart

Thank you Stewart!

But what is "Paste append" ?
My norwegian does not cover this frase. I kan only find paste vent i rightclick in excel after copying 2 rows from Excel

[MrDeej]

Thank you man!
I love you