HI All 
,
I am pretty annoyed with Microsoft! You would think that the use of data input into it's programs could be shared easily between each of the applications in its Office suite. It appears not!
It would be extremely advantageous to my cause if I could move data in and out of a database from MS Office Template documents Word and Excel!!! However, having trawled forums and various search results, I cannot find a realtively simple way of doing this and it is unbelievable!
I want to be able to create a template .dotx and .xltx and then use these to:
A: accept data from an access table (usually an individual record) [export from Access into Word or Excel.]
B: be used to update an access record [import data from the spreadsheet or document into an Access record]
It seems that it is not possible, without an extensive use of VBA code. Does anyone know a relatively simple and effective way to achieve this? I would have thought that if you define fields and create relationships and links that this could happen, surely!!! For example, open a Word doc template, that has a drop down list fed by a field in an access table. When you select a specific record, it then cascades the related fields in the access table into the word documents defined fields. That seems very basic, but very powerful and I am gobsmacked that MS have not made this possible!!!!
The reason I am asking this is because I want to be able to have an 8D database, but our 8Ds need external input from suppliers and so they need an .xlsx or .docx in order to provide us with info. So we create an 8D instance in the database (where we can track and manage) and then simply create a form for the external party to fill in, simply by clicking a button. I want to avoid duplicating data entry all the time!!!!
Please note that I know Access imports and exports using a wizard, but these just create new documents and are not formatted very well!
,I am pretty annoyed with Microsoft! You would think that the use of data input into it's programs could be shared easily between each of the applications in its Office suite. It appears not!
It would be extremely advantageous to my cause if I could move data in and out of a database from MS Office Template documents Word and Excel!!! However, having trawled forums and various search results, I cannot find a realtively simple way of doing this and it is unbelievable!
I want to be able to create a template .dotx and .xltx and then use these to:
A: accept data from an access table (usually an individual record) [export from Access into Word or Excel.]
B: be used to update an access record [import data from the spreadsheet or document into an Access record]
It seems that it is not possible, without an extensive use of VBA code. Does anyone know a relatively simple and effective way to achieve this? I would have thought that if you define fields and create relationships and links that this could happen, surely!!! For example, open a Word doc template, that has a drop down list fed by a field in an access table. When you select a specific record, it then cascades the related fields in the access table into the word documents defined fields. That seems very basic, but very powerful and I am gobsmacked that MS have not made this possible!!!!
The reason I am asking this is because I want to be able to have an 8D database, but our 8Ds need external input from suppliers and so they need an .xlsx or .docx in order to provide us with info. So we create an 8D instance in the database (where we can track and manage) and then simply create a form for the external party to fill in, simply by clicking a button. I want to avoid duplicating data entry all the time!!!!
Please note that I know Access imports and exports using a wizard, but these just create new documents and are not formatted very well!
