By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,984 Members | 2,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,984 IT Pros & Developers. It's quick & easy.

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

100+
P: 157
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
Apr 20 '08 #1
Share this Question
Share on Google+
5 Replies


Expert Mod 2.5K+
P: 2,545
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
Apr 20 '08 #2

100+
P: 157
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
Apr 22 '08 #3

P: 59
pasting into a serious database table requires formatting in thai massage... ;)
Stewart alluded to it with Paste Append instead of Paste...
Apr 22 '08 #4

Expert Mod 2.5K+
P: 2,545
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
Attached Images
 
Apr 22 '08 #5

100+
P: 157
Thank you man!
I love you
Apr 22 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.