Re: GENEALOGY DB by Joseph J. Borrello

Hi Daniel,

The drivers provided as part of your current Access installation should work
fine. Also, you'll have the advantage that you can use Access to structure a
query that will produce an Excel export exactly to the liking of the Excel
to GEDCOM converter.

- David

"Daniel Rose" <noname@xxxxxxxxxx> wrote in message
news:Mjl1f.116203$qY1.80271@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hello David,
>
> Did you mean that importing from a dBASE III file directly into Excel,
> without first going through Access, should work fine; or that I already
> have the updated dBASE III drivers as part of a Windows XP or Office XP
> service pack?
>
> If these packs do not include the drivers you recommended, would there be
> a URL you know of, from which I could download them? I spent several hours
> searching in vain on Microsoft's general and Office Web sites.
>
> Thank you,
> Daniel
>
> "David" <krautusa@(rem0vethis)frontiernet.net> wrote in message
> news:inI0f.8869$cg.897@xxxxxxxxxxxxxxxx
>> Daniel,
>>
>> That should work fine for you.
>>
>> - David>
>> "Daniel Rose" <noname@xxxxxxxxxx> wrote in message
>> news:9KF0f.371412$5N3.13493@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>> Hello David,
>>>
>>> Having looked all over the Microsoft general and Office sites, I could
>>> not find a download specifically for updated dBASE III drivers.
>>>
>>> I have Windows XP Service Pack 2 and Office XP (=2002) Service Pack 3
>>> installed. Would either of those include the current DBase III drivers?
>>> For instance, one page on microsoft.com states,
>>>
>>> "Microsoft Data Access Components (MDAC) 2.8 SP1 contains core Data
>>> Access components such as the Microsoft SQL ServerT OLE DB provider and
>>> ODBC driver. This redistributable installer for the MDAC 2.8 SP1 release
>>> installs the same Data Access components as Microsoft Windows XP SP2.
>>>
>>> "This release does not include Microsoft Jet, the Microsoft Jet OLE DB
>>> Provider or ODBC driver, the Desktop Database ODBC Drivers, or the
>>> Visual FoxPro ODBC Driver."
>>>
>>> I couldn't find the "Desktop Database ODBC Drivers" anywhere, in case
>>> you are referring to those.
>>>
>>> From another angle, Excel 2002 will either "open" or "import" "dBASE"
>>> files. Would that work, or would I need the "dBASE III" specificity of
>>> Access?
>>>
>>> Thank you,
>>> Daniel
>>>
>>> "David" <krautusa@(rem0vethis)frontiernet.net> wrote in message
>>> news:keE0f.8840$cg.7961@xxxxxxxxxxxxxxxx
>>>> That should not be a problem. However, take note that Microsoft has
>>>> updated database drivers for DBase III that you should download before
>>>> opening the DBase III files.
>>>>
>>>> "Daniel Rose" <noname@xxxxxxxxxx> wrote in message
>>>> news:uJA0f.108682$qY1.72694@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>>>> Thank you for the valuable advice. It will take about a month to get
>>>>> the files from the cousin who developed them. I will get back to you
>>>>> then.
>>>>>
>>>>> I assume Access _2002_ would work. Its "Open/Files of type" drop-down
>>>>> list does include "dBASEIII (*.dbf)". It will not "Save As" Excel,
>>>>> but will "Export to" Excel.
>>>>>
>>>>> --Daniel
>>>>>
>>>>> "David" <krautusa@(rem0vethis)frontiernet.net> wrote in message
>>>>> news:CD_%e.418$647.137@xxxxxxxxxxxxxxxx
>>>>>> As long as the information is stored in a DBase III format it can be
>>>>>> "easily" retrieved. There a number of inexpensive applications on the
>>>>>> market that convert DBase formated information into more common and
>>>>>> open structures.
>>>>>>
>>>>>> One way to achieve this is to import the DBase III file into a
>>>>>> Microsoft Access database (using Access 2003), then saving the
>>>>>> resulting data into a Microsoft Excel spread***. That file can then
>>>>>> be converted into a GEDCOM format using the Excel to GEDCOM converter
>>>>>> discussed at http://rmhh.co.uk/legacy.html
>>>>>>
>>>>>> Let me know how you make out!
>>>>>>
>>>>>> David Moufarrege, MCP
>>>
>>>
>>
>>
>
>


.