Search results

I have many varied lists of citizens from our town from 1700s to present day. Some have come in Excel, or Lotus format, most are docs. At this point I have been able to parse everything into Excel, however I now have about 60 Fields because of the variety of data garnered from each list. Over...

Great Webpage, but Thanks RexesOperator for you reply. This is a great page, but at the bottom are the Excel and Mac paragraphs, and that analysis shows why trying to deal with dates in any format other than as numbers makes it difficult to exchange data with others. My problem is that the...

Thanks Doc Man for your reply. Yes, I realized early on that dates were going to be a real problem with MS, but it is the standard, however dysfunctional. There is an addin from this site <http://www.j-walk.com/ss/excel/files/xdate.htm> that helped me with parsing the Excel files. When I...

More worms! Thanks liddlem for your reply. As I lack the experience, I will run your idea by my friends and see what they think. "Formatted correctly". Yes one of the things I have been doing is cleaning up the format problems. Data entry by inexperienced people who might add a space after...

First of all, I had some experience many years ago with setting up a db. Nothing since, so if I am in the wrong place, please feel free to say so. I am in charge of a very large list of people, mostly dead, for a historical society in my town, and much of the data is on paper or in Excel...