I agree: frustrating. However, simply create a new table in Access (let's call it tblTEMP). Paste your values from Excel into tblTEMP (perhaps we'll call the field, fldTEMP). Copy fldTEMP and paste into your desired field in desired table. No importing - no sorting against our will.