#1
|
|||
|
|||
importing bulk info from excel...(updated)
I have a excel file that has over 32,000 rows each one with 13 columns. This information deals with Books (name, author, summary, chapters, word count, etc); I am trying to find some way of displaying this information in a word document with out having to copy and paste all that information.
Does anyone know of a nice tutorial that might help me with this? EDIT: Can this not be done? Or do you need more information? Last edited by herbycanopy; 03-26-2010 at 01:40 PM. |
#2
|
|||
|
|||
Since nobody told me that it can not be done I must have done a bad job explaining this. Is there some way that I can make a "template" has the names of the columns like this...
Code:
<Story name> By <Author> <Summary> <Rating> - <Word Count> - <Chapters> Code:
Quest of Word Knowledge By Herby Canopy This is the story of A mans quest of the forbidden knowledge of Microsoft Word. PG-13 - 20,543 - 16 The Return Quest of Word Knowledge By Herby Canopy This takes off where we last saw the hero in his Quest of the forbidden knowledge of Microsoft Word. PG-13 - 22,747 - 21 |
#3
|
|||
|
|||
You did a fine job of explaining. It's my first day on the forum, and I don't know why you didn't get any answers.
You need to use the mail merge function of Word to get your data out of Excel and into Word in an attractive format. I know you're not making letters, but this would probably fall under the "directory" option of the mail merge settings. Doing this is a 4-step process. There's lots of details, but it's easy to learn. This tutorial will probably be all you need: http://office.microsoft.com/en-us/he...349201033.aspx Post back if you get stuck. |
#4
|
|||
|
|||
Quote:
lol Thanks I know how I need to do it for next time now. Aloha |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trouble importing from web page into Excel 2007 | JHCOLVI | Excel | 0 | 02-25-2010 12:18 PM |
Importing individual cells from Excel to Word | themangoagent | Word | 1 | 10-12-2009 08:14 AM |
MS OUTLOOK Bulk Mailing stalling after 2 minutes | ajetrumpet | Outlook | 0 | 07-25-2009 09:47 PM |
Move info from Word to PowerPoint? | brussee | PowerPoint | 0 | 11-03-2008 08:55 AM |
info on calander | newbee | Outlook | 0 | 01-27-2006 09:19 PM |