SBS - The best value in QMS software

Exporting Data from MS Access to MS Word or MS Excel Templates

Manix

Get Involved!!!
Trusted Information Resource
#1
HI All :bigwave:,

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!:mad:

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!
 
Elsmar Forum Sponsor
M

mguilbert

#2
Last edited by a moderator:

howste

Thaumaturge
Super Moderator
#3
If all you need is an 8D form populated from an access database, then you can use the mail merge function. Use the Access database table for the data source, and select the record(s) you want.

If you want the supplier to be able to enter data that goes back into the database automatically, I think you're out of luck.
 

Manix

Get Involved!!!
Trusted Information Resource
#5
Thanks to you guys for replying, but none of the solutions offered will do what I want it to do. I cannot believe that M$ make this so difficult,it seems crazy how hard it is for this to work!!

We are implementing a new, integrated ERP system in the next few months which I think will take care of this as it has a bolt on workflow module for information flow both internally and externally. Will have to wait until then!!!
 
Thread starter Similar threads Forum Replies Date
M Exporting Minitab Data to Excel Excel .xls Spreadsheet Templates and Tools 5
S ISO 9001 implementation in a Gold exporting business ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
R Exporting to Canada and MDSAP Canada Medical Device Regulations 7
J Exporting Medical Devices - What is needed from the receiver? Medical Device and FDA Regulations and Standards News 1
DMLqms Exporting into the EU from UK after Brexit EU Medical Device Regulations 3
C Exporting Demo Medical Devices from USA Other Medical Device Regulations World-Wide 2
S New problems exporting to Germany - February 2019 ISO 13485:2016 - Medical Device Quality Management Systems 7
E Regulatory Requirements for Exporting Medical Devices to Bonaire EU Medical Device Regulations 1
Edward Reesor Exporting from China - Unified Social Credit Code ISO 13485:2016 - Medical Device Quality Management Systems 2
M Exporting Medical Devices to Saudi Arabia Other Medical Device Regulations World-Wide 3
C Exporting Adult Products from Europe to the United States 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
R Exporting to Korea a demonstration only medical device Other Medical Device Regulations World-Wide 2
ScottK Exporting a medical device to Turkey Other Medical Device Regulations World-Wide 2
J Exporting Add-On for Medical Devices to the US - FDA Requirements Other Medical Device Related Standards 3
D Exporting batteries (spare parts) to China China Medical Device Regulations 2
B Exporting Medical Devices to Kenya Other Medical Device Regulations World-Wide 2
T CE Marking - Exporting replicas (Airsoft) to Europe CE Marking (Conformité Européene) / CB Scheme 1
Q Distributor Contracts and Exporting ISO 13485:2016 - Medical Device Quality Management Systems 2
S Pre-Approval Requirements - Exporting Medical Devices to China from the US China Medical Device Regulations 4
L GMP (Good Manufacturing Practices) for Wind Turbine Manufacturing and Exporting Other ISO and International Standards and European Regulations 3
N Exporting Class III Medical Devices to Canada from Israel Canada Medical Device Regulations 12
R Requirements for Exporting Class III Medical Devices into the UAE from the US or EU ISO 13485:2016 - Medical Device Quality Management Systems 2
B Requirements for Exporting Medical Devices to Libya Other Medical Device Regulations World-Wide 5
K Exporting a Class II Medical Device into Kuwait from the US Other Medical Device Regulations World-Wide 3
S Exporting then re-Importing 510(k) device 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 3
B Exporting to and Selling Devices in Spain EU Medical Device Regulations 15
T TGA - Application Fees - Exporting Medical Devices into Australia market Other Medical Device Regulations World-Wide 5
K Requirements for Exporting from US to EU - Class I MD non-sterile, non-measuring EU Medical Device Regulations 7
C Shipping Non-CE products to EU for exporting to other countries CE Marking (Conformité Européene) / CB Scheme 4
Q GeoMeasure 6000 - Exporting buffers to a file Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
A Shipping Validations prior to exporting our product ISO 13485:2016 - Medical Device Quality Management Systems 4
C Exporting Minitab outputs to other programs (Powerpoint)?? Using Minitab Software 5
B Requirements for Exporting Medical Devices to Australia Various Other Specifications, Standards, and related Requirements 25
C Exporting Ford's 'FMEA Plus' Files to Excel Excel .xls Spreadsheet Templates and Tools 13
Q AMS 2750 E or F Continuous Furnace TUS Data Collection AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
M Reduce occurrence rating based on the PMS data and customer complaint data ISO 14971 - Medical Device Risk Management 2
J Customer Complaint & SCAR, false data Nonconformance and Corrective Action 14
Brizilla Employee Data Privacy Policy - ISO 9001:2015 requirement(s)? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
D Safety data sheets software REACH and RoHS Conversations 2
M Data Protection and Privacy Policy - looking for a template/example EU Medical Device Regulations 1
S Non parametric test for semi-quantitative data. Statistical Analysis Tools, Techniques and SPC 5
M Disabling measurement data during fault conditions IEC 60601 - Medical Electrical Equipment Safety Standards Series 5
C EU MDR - Annex II 6.1 Pre-clinical and clinical data EU Medical Device Regulations 4
P Ppk results shown as asterisk after the transformation of Non-normal data Using Minitab Software 4
lanley liao How to correctly understand the bullet list d) of 6.3 Analysis of Data for API Spec Q1 Oil and Gas Industry Standards and Regulations 7
Steve Prevette Informational I am presenting a webinar Thursday - "Data Driven Decision Making" - 19 November 2020 Statistical Analysis Tools, Techniques and SPC 5
qualprod Best practice to ensure inputting of data in production Lean in Manufacturing and Service Industries 19
D Preservation of Electronic Data / Information Technology ISO 13485:2016 - Medical Device Quality Management Systems 5
M Comparing data from destructive testing Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
DuncanGibbons Technical Data Package vs Digital Product Definition APQP and PPAP 0

Similar threads

Top Bottom