Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / June 2004

Tip: Looking for answers? Try searching our database.

Exporting/Linking to WordPerfect?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sandra - 10 Jun 2004 21:49 GMT
This is what I want to accomplish:

I have a document in WordPerfect that needs to have
fields inserted from my Access database and be launch
from within Access. (Basically picture a Report but in
WordPerfect so that it's fully editable by the user)

This is my plan:

Export data from Access query into a format readable by
WP (CSV or something, I suppose) and perform a merge in
WP.  

Is this the best way of going about this? This all needs
to be automated and seamless for the user, of course, so
I would create the necessary macros in WP to run the
merge.   Seems to me there should be a better, more
efficient way.  Can you point me in the right direction?  
The biggest problem I'm having right now is figuring out
what's the best way to get the data into WordPerfect from
the Access query... (I can do some VBA and I'm not afraid
to get into automation and interoperability)

Any help would be greatly appreciated! TIA!
John Nurick - 12 Jun 2004 19:21 GMT
Hi Sandra,

Few if any here know much about WordPerfect, and I'm not one of them.
But it shouldn't be necessary to export the data from Access; instead,
check out the WordPerfect documentation on merging from an ODBC data
source.

Going a step further: recent versions of WP can be automated from other
VBA-compatible applications such as Access. Again, check out the WP
documentation.

>This is what I want to accomplish:
>
[quoted text clipped - 20 lines]
>
>Any help would be greatly appreciated! TIA!

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.