Importing / Exporting / Full application Creation Advise Please

D

Dermot

This is a very general question and I am only seeking guidance in how to
combine everything into one application. I am not too sure the best way to
ask my questions so please persevere.

I have many Word 2002 / 2003 Documents of inter-related information.
Excel 2002 /2003 spreadsheets, and a Access 2002 database which use common
data. At the moment I am entering the information into each application
manually.
Questions
1. What is the best way to approach Automating inserting the common data
into both Word and Excel from the database.

2. If the Access database is converted to a SQL client server database for
use on the internet as a source of obtaining the data, what is the correct
approach to online entered data being co-ordinated with the Word and Excel
spreadsheets.

3. Can eveything, Excel, Access and Word all be combined into one complete
application.

4. Can Data be imported into word documents? i.e from excel or visa
versa....which is the correct way to appraoch this task?

Any help in the form of links to reading material, sample tutorial
applications, words of development wisdom / guidance, would be appreciated.
 
B

Beth Melton

XML could be what you are looking for. It won't combine your data into
one application but it will provide a means of sharing data between
the applications without the need to manually reenter the information.

"Microsoft Office System and XML: XML in Action"
http://msdn.microsoft.com/library/d.../dno2k3ta/html/odc_ofofficesysxmlinaction.asp

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
B

Beth Melton

D

Dermot

Thanks Beth

Beth Melton said:
Perhaps this article will give you a little more insight:
http://msdn.microsoft.com/library/d...dno2k3ta/html/ODC_OFXML_in_Office2003_jrd.asp

You'll also find additional XML articles on MSDN.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
Click to expand...
 
Top