TMG-L Archives

Archiver > TMG > 2001-11 > 1005006583


From: "David Carnley" <>
Subject: RE: [TMG] Editing timelines
Date: Mon, 5 Nov 2001 18:29:43 -0600
In-Reply-To: <006d01c16641$f215b1e0$4c2d7bd5@hstjw>


Hugh

>From Excel Toolbar choose
Data - Get External Data - New DataBase Query

Double Click on dBase Files*

Dialog Box
This data source contains no visible tables
click ok
Query Wizard - choose Columns
click cancel
click Yes
navigate to your timeline file
click add then close

Microsoft Query dialog
double click the *
>From toolbar - File - Return Data to Microsoft Excel

in Excel choose upper left corner for table
click Ok

That's it


David

David Carnley -- Newton, Texas
E-mail: mailto:
My website: http://www.carnley.net


:-----Original Message-----
:From: Hugh Wilding [mailto:]
:Sent: Nov 05, 2001 3:36 PM
:To:
:Subject: Re: [TMG] Editing timelines
:
:
:Caroline Gurney asked:
:
:
:[snip]
:> When I open timeline *.dbf files in Works, the Year, Month & Day fields
:> contain the dates but the Event field is always empty. Where is that
:> information stored & how can I edit it?
:
:Works is not the only app to have this problem. MS Excel 2000 also loads
:with empty Events fields.. MS Access 2000 wants to know where the *.ndx or
:*.mdx files are held but I can only see *.cdx ones (for timelines that I
:have added - the "bundled" timelines don't have these).
:
:I know little about dBase but from what I see in Explorer, it looks as if
:the Event text is stored in the .DBT file that is associated with the .DBF
:file.
:
:Hugh Wilding
:Berkshire, England
:<>
:
:
:==== TMG Mailing List ====
:Please remove any "Reply-To:" address in your e-mail program.
:Including a "Reply-To:" prevents others from benefiting from
:replies to your questions.
:
:

This thread: