Copying from excel to access form

[hansdbase]

I think I have tried everything. when I copy cell by cell into one row of the form, it works. When I try to copy the row at once, it doesn't. It says text entered isn't an item in a list but again, it works when I do each cell individually and I see no validation issues. Any ideas? Thanks.

[Micron]

You're trying to copy a range of Excel cells and have the paste operation populate a bunch of form controls in Access? Cannot. If that's not the case then I don't understand what you're doing.

[hansdbase]

I can't copy a row of 5 fields in excel to a row of 5 fields in an access form with identical field names and validations? I can copy each field from the excel row into the corresponding field of the access record individually. Just wondering why I can't copy them all at once.

[Micron]

Should have asked what type of form this is. I presumed it was not a datasheet or continuous form. If it is, then you should be able to paste if you select the record selector first - as long as the pasted data doesn't violate any constraints. If you chose to hide record selectors, then I don't know if you can do it.
The message you got implies that you can paste, but one of the form controls is a combo box with Limit To List property set to True, which would mean entered data has to be in the list for that control. I would think that should rule out being able to paste blank cells as well, so maybe check that.

If you can copy/compact and zip a db here that would help. See how to attach files at the top of forum window if you need it.

[hansdbase]

I noticed that although my excel fields match up with my access form fields as displayed, they are not matching up in reality. I determined based on trial and error that if I rearrange my excel fields and copy and paste it works. How can I determine how my control fields are arranged, that is in what order they are arranged, for ingesting excel data? THanks.

[Micron]

Look at the form recordsource. The left to right order of the fields in a table or query recordsource is the left to right order as seen in the table or query.