Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

rtf files

Status
Not open for further replies.

Ptrif

Technical User
May 19, 2003
106
US
I am trying to import files from another database into access, however the other program only creates .rtf files. Is there anyway to import these directly into access without having to manually manipulate the .rtf file?

any help is appreciated.

Paul
 
Hi Paul,
"from another database" - are you sure you cannot create other than rtf from the application?

If not: The easiest way I can think of is to write a Word macro, that will cycle through all your rtf and save them as text only.

Then import those text files...

Anyone other ideas?

Hope this helps,
Andy

[blue]The last voice we will hear before the world explodes will be that of an expert saying:
"This is technically impossible!" - Sir Peter Ustinov[/blue]
andreas.galambos@bowneglobal.de
HP:
 
This part of code takes a Word document save as RTF format. ActXctl8 is a richtext control on a form. You should be able to reference someplace else to "drop" your information.

oDoc.SaveAs Filename:="C:\My Documents\MySpellCheck.rtf", FileFormat:=wdFormatRTF
With oWord
.ActiveDocument.Close savechanges:=True
.Quit
End With
ActXCtl8.Filename = "C:\my documents\mySpellCheck.rtf"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top