When you use Base to connect to a spreadsheet, the tables are read
only. You can not add nor modify data in the spreadsheet using Base.
What you can do is create the spreadsheet in Calc (which I think
you may have already done). Use Calc to update the spreadsheet. Also use
Base to connect to the spreadsheet which creates a .odb database
document file. Using this file you can create forms, queries, and or
reports of the spreadsheet.
One slight problem that I have noticed. When Base opens the
database file, it gathers information from the spreadsheet at that time.
But any updating of the spreadsheet is not reflected in tables of
the .odb file. After updating the spreadsheet, Base must be closed and
then opened to show the updated data.
--Dan
Thanks so much for the information. I'm understanding more and more that base
won't do what I'd love to do -- have a live database in front of me that
updates information as you enter it. The Linux world is absolutely miserable
when it comes to offering database clients. Lots of SQL stuff, some embedded
code, etc. The old DOS world was perfect -- had lots of offerings, like Q&A,
Alpha Four, File Express, etc. It seems we've moved beyond the simple. It's a
pity.
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
