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?
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"
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.