Get External Data in Excel 2007

I created this Excel Video Lesson in response to a viewer request. He wants to learn how to move files that contain dates, text and numbers from a different program into Excel. Excel 2007 gives you an easy to follow Wizard from the Data Tab of the Ribbon to Get External Data.

As I stress in this lesson – “Resist, resist, resist … the urge to go to the Office Button (File Menu) and choose Open. No, no , no… Use the Get External Data Wizard. Watch this short lesson to see how to bring information in from Word 2007 and from Access 2007. I also show you how to save an Excel 2007 file as a Text File (.txt) to make it easy to open it in almost any program.

If you enjoyed this lesson, I invite you to shop for my DVD, “The 50 Best Tips for Excel 2007.”The Store for The Company Rocks is a secure shopping site. And, I personally guarantee your satisfaction – or I will refund your purchase price! Click here to start shopping.

You can watch this Excel Training video on my YouTube Channel – DannyRocksExcels

Related Videos

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn


  1. Marko Kamacho says:

    I saw your video and I practice importing a couple of files and everything was fine, but I have a question, how can I import using a macro multiple files at once, assuming that these are in a folder and move these to an Excel workbook is ie each file paste into a sheet of excel workbook.

Speak Your Mind