If you want to transfer the data in your existing speadsheet to the
database, it's not too tough. Do a "Save As" selecting the "text"
option for document type. Then, select the "Open" command. A window
will appear, and there you'll choose the database as the type of
document you want and select ASCI Text as the type of document you're
wanting to import into the database. Select the document you exported
from the SS, and click "Open." You may need to name the fields
manually, and you'll probably want to check the formatting of each of
the fields. But overall, it's a quick process.
Bill Holt
On Monday, August 15, 2005, at 11:53 AM, Bill Micou wrote:
> Wow, thanks for the help and suggestions. I returned from a week-end
> trip and discovered all your great ideas. I have always ignored the
> database option, but knew in the back of my mind (where I keep all the
> right answers), that may be the better way. I played with it some
> last night and think I'm ready to really learn it's many facets.
> (flash back...Dick Smothers doing the comedy bit about ' being a many
> faucet-ed person') Any tutorial sites for the DB beginner?
> Thanks again,
> Bill Micou
> On Aug 14, 2005, at 1:24 PM, Anne Cartwright wrote:
>
>> I agree with Bill Holt. Unless you are primarily doing calculations,
>> I think you will find the database much more useful. It is much
>> better at sorting and finding (one or more) records. Also easier to
>> add records. And you can rearrange the database lots of different
>> ways. You can even do some calculations; mostly summary fields.
>>
>> Anne Cartwright
>>
>>
>> On Saturday, August 13, 2005, at 12:02 AM, Bill Holt wrote:
>>
>>> I think you've been told right, Bill, about extending the print
>>> range, but thought I'd mention that you might be better off using
>>> the database application instead of the spreadsheet. The db should
>>> allow you a nearly unlimited number of records (limited only my
>>> computer memory) and instead of moving all the data down a row each
>>> time you want to add more, all you do is click "New Record" and then
>>> you can sort according to any of your criteria with a simple click.
>>> The db is a little more trouble to set up but much easier to use and
>>> capable of handling much more data.
>>>
>>> Bill Holt
>>>
>>>
>>> On Friday, August 12, 2005, at 09:52 AM, Bill Micou wrote:
>>>
>>>> Anyone using Appleworks for simple spreadsheets? I'll ask you all
>>>> first before I try the AW user group.
>>>> I set up a spreadsheet to record some household data. Several
>>>> times during the week, I insert a new horizonal line of cells to
>>>> the very top (under my headings) in order to have the most current
>>>> info on the first line. Everything has been working fine, until I
>>>> scrolled down to the bottom of the spreadsheet. Apparently when I
>>>> set this one up, I limited the vertical cells to only 134. So my
>>>> 'form' stops at this point and every time I have added a new line
>>>> at the top, my oldest info on the bottom line is disappearing.
>>>> How do I extend my spreadsheet to be longer?
>>>> Is my oldest data lost, or just not visible because there are no
>>>> lines?
>>>> Any ideas? Thanks.
>>>> Bill Micou
>>>>
>>>>
>>>>
>>>> | The next meeting of the Louisville Computer Society will
>>>> | be August 25. The LCS Web page is <http://www.kymac.org>.
>>>> | List posting address: <mailto:macgroup at erdos.math.louisville.edu>
>>>> | List Web page: <http://erdos.math.louisville.edu/macgroup>
>>>>
>>>
>>>
>>>
>>> | The next meeting of the Louisville Computer Society will
>>> | be August 25. The LCS Web page is <http://www.kymac.org>.
>>> | List posting address: <mailto:macgroup at erdos.math.louisville.edu>
>>> | List Web page: <http://erdos.math.louisville.edu/macgroup>
>>>
>>
>>
>>
>> | The next meeting of the Louisville Computer Society will
>> | be August 25. The LCS Web page is <http://www.kymac.org>.
>> | List posting address: <mailto:macgroup at erdos.math.louisville.edu>
>> | List Web page: <http://erdos.math.louisville.edu/macgroup>
>
>
>
> | The next meeting of the Louisville Computer Society will
> | be August 25. The LCS Web page is <http://www.kymac.org>.
> | List posting address: <mailto:macgroup at erdos.math.louisville.edu>
> | List Web page: <http://erdos.math.louisville.edu/macgroup>
>
| The next meeting of the Louisville Computer Society will
| be August 25. The LCS Web page is <http://www.kymac.org>.
| List posting address: <mailto:macgroup at erdos.math.louisville.edu>
| List Web page: <http://erdos.math.louisville.edu/macgroup>
