Dana,
I have been using WriteLog's ability to produce an Excel spreadsheet for
each contest or general dx qso. Then from Microsoft Access I import the
spreadsheet. Then I build an append query to map the fields I want over
into my master "Contacts" table. This has been working out fine for each
contest. I am saving the append queries under the assumption that when I
get to that same contest a year later the query will still be valid. It
only takes a few minutes to accomplish after each contest and you have the
excel spread sheet to do any analysis you want.
The only difficulty I have encountered seems to be a limit on Access not
importing more than 32 fields so I have had to delete some Excel columns at
times. Don't understand this limit yet.
Jerry, W6IHG
At 09:27 AM 3/26/99 PST, you wrote:
>I am embarrassed to admit that I have tried some very strange kluges to get
>into one file... tried writing an Access database to import to, but it's
taking
> forever & I don't have much time to work on it... finally tried using the
>shareware XMLog... it takes the import file OK (at least it seems to) and
does
>the basic tracking functions, but you are pretty limited in what you can do
>with it
>
>______________________________________
>Dana Phillips
>General Counsel
>Legal Department
>Sacramento Housing & Redevelopment Agency
>630 I Street
>Sacramento, California 95814
>916.440.1330 Telecopier 916.441.1197
>dphillips@shra.org
>dwp@deepwell.com
>---------- Original Text ----------
>
>From: "Michael C. Joens" <joens@thecia.net>, on 3/25/99 7:52 PM:
>
>I would like to combine the various contest logs into one for DXCC tracking
>purposes. After several contests the information becomes a bit unwieldy to
>handle in separate logs. I looked through the help screens, but couldn't
>find any way to merge several logs into one.
>
>I tried to export each log into the ADIF format and then importing it into
>LOG-EQF, which I use for non-contest logging. However, the resulting file
>does not track the countries correctly, which may be a problem with how the
>ADIF file is imported into LOG-EQF. At any rate, that approach did not
>work.
>
>If I could at least combine all the .WL files into one, that would be a
>great step forward. I'm sure it can be done, I just can't figure out how.
>
>73,
>Michael
>
>
------------------------------------------
Dr. Jerry R. Pixton, PIXOS Designs
http://www.pixos.com/designs/
jpixton@shentel.net
------------------------------------------
|