Hello,
Please how do I convert formatted text in a word document into markedup text in a memo field in MSaccess, and retain the formatting. I have created a form to display the contents of a word document, and intend to use Leban's RTF2 control to view the file's contents. Your response will be most valued.
4  4954  nico5038 3,080
Recognized Expert Specialist
I would save the word document in .rtf format and import that into the Leban's control.
Nic;o)
I would save the word document in .rtf format and import that into the Leban's control.
Nic;o)
Thanks Nico. How would you do the import? There's a table containing about 50 records, and each record has a unique document to be inserted into a memo field.
nico5038 3,080
Recognized Expert Specialist
You could try code, but (especially when there's already formatting in the docs) I would just open the table and a form with the control side by side and use the CTRL-C and CTRL-V to copy/paste the text.
Guess creating and testing the code solution takes just as long...
Nic;o)
You could try code, but (especially when there's already formatting in the docs) I would just open the table and a form with the control side by side and use the CTRL-C and CTRL-V to copy/paste the text.
Guess creating and testing the code solution takes just as long...
Nic;o)
Thank you very much!!!
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: DCM Fan |
last post by:
Access 2K, SP3 on Windows 2K, SP4
All,
I have an import spec set up with quoted Identifiers and comma-separated
values. The text file is produced by a 3rd-party program of which I have no
control. It outputs all text fields surrounded by quotes, and all numeric
fields w/o quotes. All fields are separated with commas.
This has been working for 2 years, until today, when one of the data fields
|
by: mark |
last post by:
In Access 2000 and 2002, I have created an import specification to import the
fixed-width recordset below into an existing table. I am having strange
problems with the import of the date and time fields.
177 102003 16:43:12 102003 18:43:12 6OAG0ADP Y 0000 0000 0000 0000 61930 4HGA800
165 102003 17:43:12 102003 18:44:12 6OAG0ADP Y 0000 0000 0000 0000 61930 4HGA800
177 102003 16:41:18 102003 18:45:12 6OAG0ADP Y 0000 0000 0000 0000 61930...
|
by: Johnny Meredith |
last post by:
I have seven huge fixed width text file that I need to import to Access.
They contain headers, subtotals, etc. that are not needed. There is also
some corrupt data that we know about and can correct once the data is in
Access (or during the import process itself). Furthermore, the text files
are poorly set up, such that some records may be "shifted" over a few
characters, and therefore the fixed width nature of the file is corrupted.
...
|
by: Erick |
last post by:
Is it possible to store formatted text into a memo field. From for example
Visual Basic?
|
by: Radu |
last post by:
Hi. I got a "|" delimited file, and one of its columns (the last one)
is MANY chars long.
If I use my try to manually import the file, the text in the last
column is cut off at char 255, as it should.
I have tried to import it by code - I have created a target table in
Access where the "LongText" field, the last one, is of type Memo. Then
I have tried to open the text file with an OpenDatabase command, then
go thru the recordset...
| | |
by: NewbieSupreme |
last post by:
I'm using PHPMyAdmin on an Apache2Triad install (latest version; 5.x.x,
which installs PHP5 and PHPMyAdmin 2.8 as well). In Access, I exported a
table to a text file, tab-delimited, text qualifyer of "none" (this is how I
read to do it from newsgroups).
When I use the Query window in phpmyadmin to import the text file, it waits
a while, then returns an error:
#1064 - You have an error in your SQL syntax; check the manual that...
|
by: ninrulz |
last post by:
I will try to explain my situation. I know that it is hard to offers
solutions without fully understanding what people would like to
achieve.
I receive 2 csv files every month. The csv files change name each
month. Each file contains 13 columns and around 20k rows. In each file,
the first row is the heading.
I have created a database that helps me sort out the data. Prior to
importing into the database, I have been copying the csv...
|
by: Pete D. |
last post by:
I haven't played with this but just a thought, I remember reading this is
stored as HTML. I remember,
http://allenbrowne.com/Access2007.html
again this might be a hint.
"CES" <ces@noemaill.comwrote in message
news:u%23ilTzD7IHA.4204@TK2MSFTNGP03.phx.gbl...
|
by: jollyroger |
last post by:
I have searched the web forums, and can't seem to find an answer to this particular problem I have.
In an excel sheet, cells in one column have formatted text in the "wrapped" cells. For many of the cells it is far more than 256 char.
After import to Access, the carriage return (CR) and Line Feed (LF) is shown with a square symbol in the text, and the text is just "dumped" into the field without CR or LF. Have also tried to indentify the...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
