Hi Janet,
Not directly. However, you can save your Word document first as a web page (.htm / .html file
extension) using Word's File > Save As... feature. You can then use Access' File > Get External
Date... > Import feature to import one or more tables contained within the web page file. You
might be able to link to the web page file as well, so that you can continue to edit it in Word,
but in general I do not recommend attempting to rely of linked data that is not in Access' native
format (ie. .mdb file). The import wizard in Access will make a best guess as to the data type
for each field--be prepared for it to make some incorrect guesses. You should open the resulting
table in design view and verify that the data type is appropriate for the data in each field.
Another alternative would be to take a copy of your Word document and strip all normal text out
of it, leaving only a single table. Then use Word's File > Save As feature and save it as a comma
delimited text file. Access has a text import wizard that should be able to easily handle such a
file. The same caveat applies about whether or not the import wizard will select the appropriate
data type.
Finally, you can create an empty table in Access first, where you decide ahead of time the
fieldnames and correct data types. Then establish a link to the data. Create an append query to
append the data from the linked source to your pre-defined table. This method will probably need
to wait until you learn about the various types of queries available in Access.
Tom
_______________________________________
Can I import a Word table into Access. It would be useful for me to have the
information in both programs, but if I have to enter it twice, then I'll
just use Access. I am very, very, new to Access.
