Converting

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
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.
 
Back
Top