Import Word & Access Data Files in Excel 2007

I created this video lesson to answer a viewer's request for help in moving information from another program into Excel. Use Excel's "Get External Data" tool to guide you through this process. Do NOT use Office Button (File) Open. You gain better control over the data when you use "Get External Data."

I show you how to import both text files and files stored in Microsoft Access.

Please visit my website - www.thecompanyrocks.com - to view all of my video lessons.

Category:

Science & Technology

Tags:

• MS
• Microsoft
• Excel
• 2007
• Import
• Get
• External
• Data
• Access
• Word
• Tables
• Save
• As
• Text
• Lessons
• Tutorial
• Help
• Software
• Instruction
• How
• to

[PLAYDIRTY1000]

ONCE AGAIN...THANK YOU!

[DannyRocksExcels]

@PLAYDIRTY1000

My pleasure.

Danny Rocks

The Company Rocks

[PLAYDIRTY1000]

THANK YOU SO MUCH.  I AM THE GO TO PERSON AT WORK NOW AND I GOT A PROMOTION. THANKS AGAIN!

[DannyRocksExcels]

@PLAYDIRTY1000

Congratulations on your promotion!

Danny Rocks

The Company Rocks

[cloudrock019]

my professor says that i cant used copy/paste on that. do you know the proper way to import it? i try to save it in a different format still only the text doc is the one that i can copy not the picture and i try to make it as a header and still cant open the file. im running out of options lol (its for my exam by the way)

[DannyRocksExcels]

@cloudrock019

Well, in this case, you need to be able to SELECT the Picture inside the Word Document and Copy Just the Picture. Then, in some free Graphics program - Paste it and save that Document as either a PNG or JPEG File - save it to your Desktop if possible.

Next, from Excel, pick the cell where you want to place the picture - on the Insert Tab of the Ribbon, select Picture - browse to find it and Click OK.

Danny Rocks

The COmpany Rocks

[DannyRocksExcels]

@cloudrock019

It is as simple as using Copy and Paste! Simply use the Right-mouse to click on the Picture in Word and choose Copy. Then, in Excel, right-click the cell where you want to place the upper-left corner of the picture and choose Paste.

If your are using MS Office 2007 or MS Office 2010, working with pictures and other graphic elements is much improved and allows you to apply professional effects with a minimum of effort.

Danny Rocks

The Company Rocks

[cloudrock019]

hey danny how can i import picture in a word file to excel without using a pdf converter? thanks

[DannyRocksExcels]

@bulaluigi

My pleasure. I am glad that you enjoyed my video.

Danny Rocks

The Company Rocks

[bulaluigi]

Thank you!