4 Messages
•
80 Points
Copy Data to Word Table Format
I maintain a private--no one sees it but me--Access database of movies I've seen and movies to be seen. For umpteen years, when I copied and pasted data such as actors, producers, etc. from IMDB to Word for cleanup before adding to the database, it pasted into a neat, clean table. Then it didn't do that anymore: the data was pasted with a hard return after each field, the least messy paste arrived if I selected Keep Text Only. After many frustrating weeks, I discovered that if I changed to Reference View the data again pasted into table. Much to my dismay, it didn't work one day: back to field data followed by a hard return--very messy, inconsistent, and hard to clean up. To prep that format in order to use Word's Convert Text to Table is a lot of work because sometimes there is one field for the actor's name, sometimes two. Word requires setting the number of columns for the table for import into the table. If the data doesn't paste with a consistent number of fields, I have to hand edit with an extra hard return for those that only paste with one actor name.
How can I copy data from IMDB to a Word table to facilitate cleaning it before moving it to my database. Many thanks in advance.
Col_Needham
Employee
•
7.7K Messages
•
184.9K Points
16 hours ago
1
0