My user insists on running an Access Query, highlighting the entire query, and cutting and pasting it into an Excel Worksheet. So, she had a problem that I have to solve. The query returns 56 columns X 177 Rows. The first 4 columns are text, the rest are all numeric. The worksheet is new, so there is no formatting. When she tried to paste the most recent query, she the following error message: File Error. Some number formats may have been lost. To see if there is a problem with the data, I tried copying one number column at a time. The first column had no problem. Every other column caused the error. I looked at each value in Access and in Excel and the numbers look fine. I also tried formatting a column in the worksheet as numeric, but that did no good. Any suggestions?
