Converting

[Andermatrix]

How do I convert a MS word file into a MS access file?

 

[John Nurick]

Conversion as such is not possible.

What can be done is to transfer data from a Word document into Access
tables. How to do this, and how difficult it is, depends entirely on how
the data is laid out in the document.

 

[ccorvette]

Can you spell out for me how I would go about doing this for a simple access
form that contains 1st name, 2nd name and SS# ?. What would the word
document look like and how would I import it to my access database.
thanks for your help.

 

[John Nurick]

Ideally, the Word document would look like this (I don't know how you
like to format SS numbers):

FirstName, SecondName, SSN
John, Smith, 123-456-789
Mary, Jones, 456-321-987
Eric, Peters, 333-444-987

with no character or paragraph formatting at all.

Then you

1) Save the Word document as plain text with no layout

2) In Access, go to File|Get External Data|Import

3) Follow the steps in the wizard.