Using PowerPivot’s Copy-Paste Support for Importing Data from Word
User Rating: / 0
PoorBest 
Written by Artemakis Artemiou   
Friday, 12 March 2010 00:32

One of the great features of SQL Server PowerPivot is that it supports importing data directly from the clipboard. This is quite handy in cases you want to import and analyze data fast.

An example of using the above feature is importing data from Microsoft Word. Let’s say you have a Word document containing the following table:

Read more...

 

  Tags: excel, load