[Dx-qsl] Importing LOTW award matrix into Excel

Sat Apr 4 18:35:21 EDT 2009

Thanks to Paul for sending me an Excel template, and it inspired me to try
something I should have tried in the beginning rather than getting wrapped
up in the importing function.
Simply click on the upper left of the matrix (to the left of the left
parenthesis in the Sort by box), then click all the way at the bottom right
of the matrix, then right-click Copy, select Excel, right-click Paste, and
it pasted almost perfectly. I had to tweak the headings a little, but
nothing major. 
Problem solved.
73, Joe KQ3F
-----Original Message-----
From: dx-qsl-bounces at mailman.qth.net [mailto:dx-qsl-bounces at mailman.qth.net]
On Behalf Of Joe Stepansky
Sent: Saturday, April 04, 2009 6:00 PM
To: dx-qsl at mailman.qth.net
Subject: [Dx-qsl] Importing LOTW award matrix into Excel
What's the best way to import LOTW's DXCC award matrix into Excel? I was
looking at it today and clicked the right mouse button for laughs. There
was an item labeled "Export to Microsoft Excel". Well, it didn't work. I
got a message saying press OK, then edit the query facility then try again.
Well, I did that and it goes back to telling me to press OK, edit the query
facility, etc....typical Microsoft. 

Does anybody have a good technique to download this data?

73, Joe KQ3F

______________________________________________________________
DX-QSL mailing list
Home: http://mailman.qth.net/mailman/listinfo/dx-qsl
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:DX-QSL at mailman.qth.net
This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html