Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have text in an MS Word 2007 table which I am trying to copy to an Access file. My problem is that all new lines in Word gets converted to a new cell when pasted into Access.

How to prevent this?

share|improve this question

In order for this to work, you need to make sure the number of columns are the same in both Word and Access. This may mean disabling your Primary Key as well.

Also when you paste the content, make sure you select the entire (New) row in Access.

Another option, that will probably be more flexible is to copy the table to Excel and export that to .csv, which then can be more easily imported into Access:

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .