I am trying to paste some data from Excel into Access. One of the excel fields containts a large amount of text on seperate lines (using Alt+Enter in Excel). When I paste it into Access it all appears on one line.
Can anyone suggest how I might paste it across but keep the layout on multiple lines?
If you are pasting it into a Table in Access, then after you paste it simply Open your Field wider by dragging the box Down to open it wider. (The left side of the table where the Arrow is pointing to the right showing which record you're on)