GENEALOGY-DNA-L Archives

Archiver > GENEALOGY-DNA > 2010-11 > 1289760560-01


From: Wayne Kauffman <>
Subject: Re: [DNA] New FTDNA Project Format
Date: Sun, 14 Nov 2010 10:49:20 -0800 (PST)
References: <000a01cb8388$f94d1340$9e702dae@Ken1><6DFD50A56FF444FFA6D034CB1169C5D3@DH870341>
In-Reply-To: <6DFD50A56FF444FFA6D034CB1169C5D3@DH870341>


This also works for Excel 2010. Select the option to disable Date Recognition.
- Wayne




________________________________
From: Michael L. Hébert <>
To:
Sent: Sun, November 14, 2010 1:29:11 PM
Subject: Re: [DNA] New FTDNA Project Format

Thought I would mention that there is another way to import web page data
into Excel. You open up Excel and create a new spreadsheet. On the menu
bar, go to Data > Import External Data > New Web Query. A browser-like
window will appear. Paste into the address bar the link to the results page
at FTDNA and click the Go button. The FTDNA results page will then be
displayed. There is an Options button at the top right where you can
disable date recognition. You can also select whether you want the page
imported as plain text or with the html formatting. After selecting your
options and closing that dialog box, you can then click the Import button at
the bottom right. It will ask you for the starting cell for the import and
it will then import the web page. There also may be yellow selectors on the
page where you can import only part of the page.

I am still on Excel 2003 so I'm not sure if this is still the same in later
versions.

Mike


-------------------------------
To unsubscribe from the list, please send an email to
with the word 'unsubscribe' without the
quotes in the subject and the body of the message



This thread: