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

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

Hi Charlotte

I don’t import as such I just copy and paste
I have attached a file so you can see what happens

Reply | Quote

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.

Reply | Quote

Hi Charlotte

Thanks anyway

Reply | Quote

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.

Reply | Quote