Results 1 to 10 of 10
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Importing from word to a memo field (Office 97 SR2)

    When I copy and paste text from a word doc if there any tables it creates vertical black lines, which I have to delete individualy. I have tried pasting it into notepad first but to no avail any ideas please <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>
    If you are a fool at forty, you will always be a fool

  2. #2
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing from word to a memo field (Office 97 SR2)

    I don't really see why you'd chose to copy and paste data in a table from Word into Access.
    In the case of tables, they usually serve as field delimiters for data.

    Considering the fact you're thinking about using an incontrollable data type like memo,
    in what appears to be a 'reference' situation, have you considered inserting a hyper-link to these documents instead?
    If you chose to implement this, remember not to move the documents once the link is established.

    I hope I read your message correctly and that I'm not oversimplifying the situation.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Importing from word to a memo field (Office 97 SR2)

    Hi Jazman
    Perhaps I could elaborate a bit, the word documents I recieve are from our Italian office and they are machine specifications plus hundreds of options, hence a link to the document would be of no use.

    I extract what I need into access under a code number then that memo field is used a specification document for the customer.
    I hope this is clear
    If you are a fool at forty, you will always be a fool

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Importing from word to a memo field (Office 97 SR2)

    What on earth are you going to *do* with that text once you get it into Access? You aren't going to be able to use the information in that form anyhow. If all you want to do is store the "document", then you could embed the word doc in an OLE Object field, but again, what for? If you are trying to extract those "hundreds of options", you would be better off pulling that portion of the document out into a separate doc, converting it to a table and them importing the table from Word. A Word table is tab delimited, so it will import nicely into an Access table.
    Charlotte

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Importing from word to a memo field (Office 97 SR2)

    Hi Charlotte

    It is already a word table, but when I import it into access it is seperated by vertical black lines which when I print it in a report it prints as a square box

    Just to Explain a little further I use the details as long description in a quotation.
    If you are a fool at forty, you will always be a fool

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Importing from word to a memo field (Office 97 SR2)

    How are you importing? As tab delimited or something else?
    Charlotte

  7. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Importing from word to a memo field (Office 97 SR2)

    Hi Charlotte

    I don't import as such I just copy and paste
    I have attached a file so you can see what happens
    Attached Files Attached Files
    If you are a fool at forty, you will always be a fool

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Importing from word to a memo field (Office 97 SR2)

    I don't have to look at it to know what happens. You can't copy and paste a table in Word into a field in Access. What happens is that the little boxes you see are the visual representation of the tabs that delimit the table fields. Either convert the table to text first or start doing a real import. Copy and paste is not going to work on tables.
    Charlotte

  9. #9
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Importing from word to a memo field (Office 97 SR2)

    Hi Charlotte

    Thanks anyway
    If you are a fool at forty, you will always be a fool

  10. #10
    Lounger
    Join Date
    Apr 2001
    Location
    Khon Kaen, Thailand
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing from word to a memo field (Office 97 SR2)

    Hi,

    I would suggest you to link the Doc file to your db by using Hyperlink. Or insert Microsoft Web Browser to your form then link the Doc file to it so you can view the file like you see in MS Word with all formats still there.

    HTH.
    Tim K.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •