Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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:

http://www.access-programmers.co.uk/forums/showthread.php?t=190949

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.