----- Original Message -----
From: "Anthony Chilco" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, October 24, 2005 12:08 PM
Subject: Re: [users] Base 2.0 - Connecting to a spread sheet and making
changes to it.
Hi Jack,
I've just got started with databases. I get the same result if I connect
to a spreadsheet. If I export the spreadsheet to a dbf file and connect to
it, I can modify data either in the table or in a form. What's interesting
is that when you define the source for the database, it only wants a
directory name. All the dbf files in the directory are part of the
database.
tc
Interesting! At your suggestion, I tried that and found another wrinkle.
Let's see if I can explain it
I want to create a query to summarize a field containing numbers. When I
edited the table entry for that field I found it was a Decimal [Decimal]
field. In order to summarize it in a query it has to be a Numeric field and
I did not find a choice in the drop down list to make it so. I guess I'm
just no destined to use Base without manually entering all those records
into a new Base table.
Go figure!
Jack Gillis wrote:
I have converted an Excel spreadsheet containing a database to a Calc
sheet. Now, I would like to connect Base to that Calc sheet, design a
form as well as a query or two and then be able to change the database on
that sheet via the Base form.
I don't seem to be able to make a change to the sheet's table in Base nor
add an index to it. Apparently the sheet is locked or protected some
way. So, even though I haven't designed the form yet, I doubt that it
will work.
Is there any way I can make changes to a Calc sheet's database from a
Base form?
Thank you very much.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.361 / Virus Database: 267.12.4/146 - Release Date: 10/21/2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
