D

4 Messages

 • 

80 Points

Friday, June 6th, 2025 9:08 PM

Closed

No Status

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.

This conversation has been merged. Please refer the main conversation:

Add export function for title page full credits

Employee

 • 

7.7K Messages

 • 

184.9K Points

16 hours ago

@DLK You may have better luck by clicking the “Edit page” button and cutting and pasting from the contribution interface instead. Hope this helps.

4 Messages

 • 

80 Points

Appreciate the suggestion, but selecting Edit page, Cast, Correct/Delete produces a table, but unless I'm missing something, copying and pasting from the table also produces a hard return after each field. Also, if it is a series, such as Resident Alien, the episode information column is blank: no number of episodes nor year. And, worst of all, all of the cast isn't displayed. Worst yet, doing the same thing for Lost, there is no cast at all! Besides, it makes me a little anxious to have the information in editable mode in case I get happy fingers on the keyboard and make an inadvertent change. Too much pressure!