Word to Access

  • Thread starter Thread starter Eddie Andrews
  • Start date Start date
E

Eddie Andrews

I have received some information in word documents that I
want to insert into my current access database so that it
may be cataloged with the rest of the information. Can
this be done?
 
Hi Eddie,
I have received some information in word documents that I
want to insert into my current access database so that it
may be cataloged with the rest of the information. Can
this be done?
Click to expand...
Technically, yes, using VBA. Whether it's actually
realisable in any particular situation depends on whether
there's a reliable way to identify the data in the
documents.

I suggest you follow up on this in one of the word.vba
newsgroups. When you post there, be sure to mention
- the version of Office
- how the document is structured, i.e. how can the data be
identified. Where form fields used? Is it in certain table
cells? In bookmarks? Formatted using unique style names?
Or...?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
 
Eddie said:
I have received some information in word documents that I
want to insert into my current access database so that it
may be cataloged with the rest of the information. Can
this be done?
Click to expand...

Yes, this can be done. But you'll need to do a bit of "jockeying" with
the data to get it into a format for import into Access. Easy to do for
those with experience and knowledge...perhaps hard if this your first try.

I guess what I would recommend is that you organise the data in your
Word document into a table. Each row of the table is a "record" of
data. Each column of data in the table is a "field" of data. In the
top row give each column simple one-word name.

Once organized, then select the table, and copy/paste it all into a new
Excel file. Then in Access import this Excel file into a Access table
inside the target database. There is a Wizard in Access to do this. In
Access check the field definitions to ensure they are the same as the
target Access database table(s). Then use Access queries to move the
data into the Access Tables.
 
Back
Top