If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing data into a MEMO field
How do you import an arranged text into a memo/field where `arranged text` means the text with the several paragraphs, i.e. the text split into several rows by the ENTER command. Assume that we have such arranged text in 2-3 columns and 100+ row table made by MS Word (2002). Why Word? Word allows simple text editing in one single cell (field) so one can write down a text like poems. Unfortunately, Access imports the data from Excel but not from the Word tables. On the other side, when one copy/paste the table from Word to Excel, Excel splits the paragraphs into separated cells which means more records than in an original table. Furthermore, if one save Word or Excel table into a web format (*.htm), importing these data into Access goes smoothly although with the different results. Access makes more records like Excel does or concatenates the paragraphs into one long sentence. Editing of these data into paragraphs is impossible. Finally, if one copy/paste a cell by a cell directly from a Word to Access it works fine and just as I need it. Is it possible to automate such data transfer? How to hide the ENTER command? Thank you all. |
Thread Tools | |
Display Modes | |
|
|