• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Microsoft Access newbie seeking help

buildingacomputer

Senior member
I have inherited a database that I am supposed to maintain and update. It is basically a large table with many fields. To give you an idea,

Report number, material, manufacturer, part number, Test A Result, Test B Result, Test C Result, etc. Number of fields is like 30 or 40.

I can manually enter all fields one by one. (it was maintained by my predecessor that way) But there has to be a better way since all test data are already in my Word test report.

The test report consists of many tables. Each table has some of the database fields. If I can copy and paste each of the tables, updating will be much easier.

Some specifics are:

1) Table field names and Database field names do not match. Can I change Database field names so that they match table field names?

2) Not all of the table fields are in the Database.

Please help. I don't know where to start. I will read Access manual and do self-study. Please give me some guidelines.
Thanks.
 
access can control word (and word can control access)

you could write some code in access to load the word document, and import the various fields....

see here for a similar situation.....

import word tables to access

or you write a word macro that goes through your word report, finds, selects, and copies the needed fields to your access database
 
Back
Top