All fields do not paste into query from excel

[wolfm]

I take orders that are in Excel and copy and paste them into an Access query to update my orders table. . Since converting from Access 2010 to Access 2013 just recently, I have a problem where my first Excel field does not copy into my first field in Access. The other subsequent fields do copy into Access. So, I have to type in the first field, Job #, manually into Access.




I have attached a Word doc which illustrates my problem.

Thank you!


Access issue.zip

[ranman256]

you shouldnt copy/paste. You should import.... docmd.Transferspreadsheet.