Complimentary Coursera offer for all new members
Get offer Join without the offer
In general, using copy and paste to get data into SPSS is an error prone operation, and what you describe seems like user error rather than the fault of the SPSS editor. That being said, there is a number of ways that copying can og wrong, for example due to how the clipboard interprets things. The most common I know is that the tables use different decimal point conventions, and troubles with definitions of string versus numerical variables.
It is probably much better to use the SPSS database connectivity to read the Access table directly With appropriate filtering for dates.
All the best