Hi,


Not technically a VB/VBA question but maybe you can tell me what I'm doing wrong. Having a thick day atm...


I'm copying data from an Excel (2010) sheet and pasting into selected fields of an Access (2010) table.
Usually works well, but for some reason now its skipping text data pasted into text fields. The majority of the data looks like a number (reference) but some are text. The table field is text and 255 chars.


Now when I paste it completes all fields properly except the reference field, which if it is a number (looks like one excel has it as one) then it pastes. But if its a text (or you put the single quote before the number) then it doesn't paste in the data.


I've not had this before, so wondering whether its a 'feature' of Excel/Access 2010 or whether MS have messed something up in the copy paste bit.

Any ideas welcome!