Problems Pasting from Access to Excel?

Question

Sometimes when I paste from Access to Excel it will put all of the rows in but it will only put the data into one column, even if there are multiple columns in Access. It happens a few times a day but I can't figure out a reason why it would do it sometimes and not others.

Answer 1

This Microsoft link will explain how to go back and forth between Access and Excel. I'm trusting that both files have the same structure and headings in the same order .....

Source: http://office.microsoft.com/en-us/access/HP010950951033.aspx