Import Carriage Return Within Cell

crock

New Member
Joined
May 25, 2011
Messages
1
I am trying to import a Word table into Access. First I import the table into Excel and then into Access. The problem is that the Word table has several carriage returns within each cell, except for the "key" cell, which just has a part number.As you know, Excel will will create a new row everytjime it sees a carriage return imported. This completely screws up the import. There might be two ways around this:

1. Import all Word cells other than the "key" cell as memo fields. This prevents me from searching the field. BUT, I cannot figure out how to get Access to fromat the cell as it appears in the Word table.

2. Create some sort of macro that can convert the carriage returns into something else when I import the Word table into Excel.

Anyway, the goal is to be able to cut and paste a Word table into Excel and then into Access without having to do a lot of manual doctoring of the files. Also, I need to be able to export the Access table back into a Word table with the original Word formatting. Anybody have some words of wisdom for this?

Thank you for your help!
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
try to remove all carriage returns in the Word file. use find and replace, enter "^p" in the search box (without quote), and leave the replace with box blank.
 
Last edited by a moderator:
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top