Hi Kenn,
If you create a new base file, you can copy data from a spreadsheet and paste it
directly into a new or existing table in it. You'll have to enter the field
names in row one if you don't already have a header in your spreadsheet. I've
done it only one or twice, so I'm not sure of the exact steps, but it seemed
straightforward at the time.
tc
Kenn Goutal wrote:
I have a bunch of things that I've been keeping in (OO/Calc) spreadsheets.
They're at the point where I really need to have them in databases
or, if possible, in a single database.
(They're not very closely related, but I don't want to have to open up a
different database every time I want to enter a single piece of data,
and over the course of a single day that may mean entries into half a dozen
different spreadsheets.)
However, I've looked in the Help info in OO/Base,
and found no way to make such a transfer.
At first I thought maybe I could just have the database (or each database)
open the .ods file as a data source or some such, but didn't find that.
So then I thought that I could at least export the data from the Calc file
into a .csv file, then import that into Base. However, when I run Base,
and open a .csv file, or I'm in Windows Explorer and click on a .csv file
and click on "Open with ... Base", it opens it in Calc instead.
Recommendations?
---------------------------------------------------------------------
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]
