Numbers Pasting as Text into Excel from Access 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Copying qry results into Excel values in number fields are pasted as text after row 611. Doesn't happen if use Office Link Tool to analyze qry with MS Excel. This is a recent developement, didn't happen before especially if I used the office clipboard but now it does no matter how I copy/paste.
 
This may be caused by an issue addressed in this article.

328933 Numbers That Are Copied From Access 2002 Paste As Text in Excel 2002
http://support.microsoft.com/?id=328933

If your symptoms are similar to what is mentioned here, there is a
workaround in the article, and a hotfix available from Microsoft.


Sherri Kidner MCP, MOS
Microsoft Access Support Professional
 
Back
Top